How I solved ERROR 1251: Client does not support authentication protocol requested

[Radio_Head]

How I solved the problem

ERROR 1251: Client does not support authentication protocol requested by server; consider
upgrading MySQL client


I am posting here the how to because nothing in this forum worked execpt of this step by step procedure.


Problem : when you execute mysql from command line you receive "ERROR 1251: Client does not support authentication protocol requested by server; consider upgrading MySQL client"

1) /scripts/mysqlup --force

2) open /etc/my.cnf and add

old-passwords

on [mysqld]

3) #service mysql restart

4) now open WHM and change your mysql root password
(I used a 8 chars password)


Only now, it should work !


In several posts in this forum I read add old-passwords on my.cnf . It was not enough for me . Only the procedure above fixed my problem definitely.


Bye

[Alexandre]

You can try

#mysqld_safe --skip-grant-tables --old-passwords &
#mysql -u root
#mysql>UPDATE mysql.user SET Password=PASSWORD('yournewpasswd')
-> WHERE User='root';
mysql> FLUSH PRIVILEGES;

Replace "yournewpasswd"' with the actual root password that you want to use.

[aliali]

Alexndere

thank you very much

it took me 4 days of searching untill found this way

thanks man