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

Radio_Head

Well-Known Member
Verifed Vendor
Feb 15, 2002
2,051
1
343
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

Member
PartnerNOC
Jan 21, 2004
19
0
151
U.S.A.
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

Registered
Sep 15, 2007
1
0
51
Alexndere

thank you very much

it took me 4 days of searching untill found this way

thanks man