Подпишитесь, не пожалеете!
Если не понравится, будет не интересно или скучно — потом отпишетесь в любой момент! :o)
Ещё мы периодически разыгрываем призы и пригласительные на разные мероприятия...
How to allow old MySQL client (like Zeos Database Explorer) to connect to the new MySQL (v 5.6 and newer)
Edit my.ini in Windows (or /etc/my.cnf in Linux) in of the mySQL server.
Add old_passwords=1 to [mysqld] section (UPD. Not necessary!)
Add skip-secure-auth to [mysqld] section
Restart MySQL service (in Windows) or execute /etc/init.d/mysqld restart (on Liniux).
Connect to mySQL server under the root and execute some following commands:
(Not necessary but just to make sure that previous steps was successful, and to make sure that old-style passwords of MySQL version prior to 4.1 is allowed) SHOW VARIABLES LIKE "%password%";
USE mysql;
SET password FOR 'username'@'host'=OLD_PASSWORD('password');
UPDATE user SET plugin='mysql_old_password' WHERE user="username" AND host="host";
FLUSH privileges;
That’s all! Try to connect to MySQL database with your old MySQL-client. If you will get errors like
client does not support authentication protocol requested by server; consider upgrading mysql client
then you probably did something wrong in previous steps.