connect to MySQL server with "security_auth" on

easyblue · Post by **easyblue** » Mon 21 Mar 2011 02:23

Hello

By an upgrade of our company MySQL server with security_auth option switched on, now MyDAC seems not able to connect to that server anymore.

And I also can not find an option in MyConnect for this.

How can I use MyDAC to connect to a MySQL server with security_auth on?

AndreyZ · Post by **AndreyZ** » Mon 21 Mar 2011 10:48

Hello,

I cannot reproduce the problem. Please specify the exact MyDAC and MySQL server versions you are using. Also please try using the latest MyDAC version 6.00.0.5 and check if the problem persists.

easyblue · Post by **easyblue** » Tue 22 Mar 2011 13:11

Hello

This is an old application built on MyDAC v4, and we have lost the environment to rebuild it.

MySQL server is of v5.

Now we are getting errors at connecting server for it. How does MyDAC supports this security_auth in history?

AndreyZ · Post by **AndreyZ** » Wed 23 Mar 2011 15:03

If you cannot rebuild your application using the new version of MyDAC, you can only set your password on the server to the old format. For this, you should execute the following code:

Code: Select all

SET PASSWORD FOR 'your_user'@'your_host' = OLD_PASSWORD('new_password');
FLUSH PRIVILEGES;

You can find more information concerning this problem here: http://dev.mysql.com/doc/refman/5.5/en/ ... shing.html