Recently we received lots of issues regarding following error.
================================================== =============
[error] PHP Warning: mysql_connect() [function.mysql-connect]: Client does not support authentication protocol requested by server; consider upgrading MySQL client.
================================================== ======================
It happens when you transfer your
website hosting to a new
VPS Hosting or server.
and it does not have MySQL Server password set to old style in WHM.
You can fix the problem using following steps:-
1) Login to WHM Panel.
2) Goto Tweak Settings >> MySQL.
3) Click on checkbox in front of " Use old style (4.0) passwords with MySQL 4.1+ (required if you have problems with PHP apps authenticating)". 4) Clic on "Save" to save the changes.
5) Now re-create the database user for which you are facing the problem.
6) Assign privileges to database user.
The database connection should be fine
MySQL database connection problem.
Linear Mode
