Bug #80442 mysql_real_connect using SSL throws 1045 Access denied for user
Submitted: 19 Feb 2016 10:28 Modified: 6 Jun 2016 7:33
Reporter: Tobias Lindgren Email Updates:
Status: No Feedback Impact on me:
None 
Category:Connector / C Severity:S3 (Non-critical)
Version:6.1.6 OS:Debian
Assigned to: Assigned Account CPU Architecture:Any
Tags: mysql_real_connect mysql_ssl_set

[19 Feb 2016 10:28] Tobias Lindgren
Description:
Cannot authenticate using SSL when using Connector/C 6.1.6. Disabling SSL gives expected access. Using Connector/C <= 6.1.5 works well for both SSL and non-SSL.
User grant is "REQUIRE NONE", but changing to "REQUIRE SSL" does not help either.

Tried compiling using both yaSSL and OpenSSL, but seems issue is the same regardless.

Mysql server version is 5.6.28.

How to repeat:
Use Connector/C 6.1.6 and enable client to use SSL.

# (compile program with mysql_ssl_set)
# export LD_LIBRARY_PATH=/usr/src/mysql-connector-c-6.1.6-src/libmysql
# ./mysql-ssl-test 
Real connect: 1045: Access denied for user 'user'@'10.10.10.10' (using password: YES)

# export LD_LIBRARY_PATH=/usr/src/mysql-connector-c-6.1.5-src/libmysql
# ./mysql-ssl-test 
SSL cipher used: DHE-RSA-AES256-SHA 
Thread ID is: 62082422 

# (recompile program without mysql_ssl_set)
# export LD_LIBRARY_PATH=/usr/src/mysql-connector-c-6.1.6-src/libmysql
# ./mysql-ssl-test 
SSL cipher used: (null)
[6 May 2016 7:33] Chiranjeevi Battula
Hello Tobias Lindgren,

Thank you for the bug report.
I tried to reproduce the issue at my end using MySQL Connector / C 6.1.6 with mysql_ssl_set() but not seeing any issues to connect MySQL database.
Could you please provide repeatable test case (like sample test case. - please make it as private if you prefer) to confirm this issue at our end?

Thanks,
Chiranjeevi.
[7 Jun 2016 1:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".