db error after moving server

mahdy_sharifi

Well-Known Member
Feb 26, 2012
218
1
68
cPanel Access Level
Root Administrator
Hello :

We move our user to new server and then all this user scripts can connect to db , example error :
Client does not support authentication protocol requested by server; consider upgrading MySQL client

HelP to resolve problem please .

Regards
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Have you recently upgraded MySQL on the destination server? If so, ensure you have rebuilt Apache/PHP via EasyApache to ensure PHP is built against the new version of MySQL. You may also need to enable the following option under the "SQL" tab in "WHM Home » Server Configuration » Tweak Settings" if the source server used an older version of MySQL:

"Use pre-4.1-style MySQL® passwords"

Thank you.
 

mahdy_sharifi

Well-Known Member
Feb 26, 2012
218
1
68
cPanel Access Level
Root Administrator
Hi :

Unfortunately not resolved !
Also this is new server that installed cpanel on it , no upgrade start yet.

thanks
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Could you verify which version of MySQL was installed on the source server, compared to the destination server?

Thank you.