SmokyHosts Support Forums - Webhosting and Webdesigning Support!

Posted: **Wed Mar 15, 2006 10:07 pm**

Only DB admin can help me...and other user that will have this problem

here is another solution - http://www.webhostingtalk.com/showthread.php?p=3663216

Code: Select all

The problem you are receiving is because it seems you have upgraded your mysql and as the error states "Client does not support authentication protocol requested by server" your mysql version is not supporting old authentication methods.

To fix this simply edit the /etc/my.cnf and add the following variable :

old-passwords

Also confirm that the following has been enabled in whm -> tweak settings -> Use old style (4.0) passwords with mySQL 4.1 (required if you have problems with php apps authenticating) 

Then restart mysql followed by eximstats :

/scripts/restartsrv_mysql
/scripts/restartsrv_eximstats

This should fix the problem.

and/or

Code: Select all

If you're upgrading from mysql 4.0 to mysql 4.1, and you encounter this error when attempting to use any script that makes use of DBD::MySQL, run the following:

/scripts/realperlinstaller --force DBD::mysql

everything will work perfectly after that.

Posted: **Thu Mar 16, 2006 12:28 pm**

ihtus wrote:Only DB admin can help me...and other user that will have this problem

here is another solution - http://www.webhostingtalk.com/showthread.php?p=3663216

Code: Select all

The problem you are receiving is because it seems you have upgraded your mysql and as the error states "Client does not support authentication protocol requested by server" your mysql version is not supporting old authentication methods.

To fix this simply edit the /etc/my.cnf and add the following variable &#58]

and/or

[code]If you're upgrading from mysql 4.0 to mysql 4.1, and you encounter this error when attempting to use any script that makes use of DBD::MySQL, run the following:

/scripts/realperlinstaller --force DBD::mysql

everything will work perfectly after that.

As you are quoting and advicing others to follow those instructions incase they face the same problem, so can you. There will not be any downgrading or modification of the currently stable version of the mysql server that is currently running.

Do learn how to edit your posts instead of replying to your own.

Any further assistance on this issue will be given only via PM. This thread is being locked.

SmokyHosts Support Forums - Webhosting and Webdesigning Support!

Loading "mysql" saver ... *FATAL*: MYSQL ERROR

Loading "mysql" saver ... FATAL: MYSQL ERROR