Page 1 of 1
connect to MySQL server with "security_auth" on
Posted: Mon 21 Mar 2011 02:23
by easyblue
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?
Posted: Mon 21 Mar 2011 10:48
by AndreyZ
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.
Posted: Tue 22 Mar 2011 13:11
by easyblue
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?
Posted: Wed 23 Mar 2011 15:03
by AndreyZ
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