FRIHOST FORUMS SEARCH FAQ TOS BLOGS COMPETITIONS
You are invited to Log in or Register a free Frihost Account!


[MySQL] Client does not support authentication protocol





Urahara
I have been getting this issue:

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

I know it's the old password hashing problem, so I have run these commands as they have solved this problem before:

SET PASSWORD FOR 'root'@'localhost' = OLD_PASSWORD('newpwd');

Alternatively, use UPDATE and FLUSH PRIVILEGES:

UPDATE mysql.user SET Password = OLD_PASSWORD('newpwd')
WHERE Host = 'localhost' AND User = 'root'; FLUSH PRIVILEGES;

This time it didn't work
Shocked
raver
so... just upgrade the mysql client Smile
Related topics
cron jobs
Best FTP Client on EARTH
Google Page Creator
Warning: mysql_connect(): Client does not support authentica
AJAX tutorial [2nd part now updated]
MySQL error
How can I create a User account and password for my website?
Error when connecting to MySQL
Windows XP SP3 comming soon
Ajax quiz -- 25 FRIH$
Authentication Module
mysql insert into multiple tables at once?
Problems with SQL and Frihost...
which server operating system?
Reply to topic    Frihost Forum Index -> Scripting -> Php and MySQL

FRIHOST HOME | FAQ | TOS | ABOUT US | CONTACT US | SITE MAP
© 2005-2011 Frihost, forums powered by phpBB.