KB #1758 - I cannot connect to Mysql database nor from PHP scripts nor from PHPMyAdmin however the password is correct. Only changes - MySQL was upgraded to 4.1 or newer version recently.

RESOLUTION

SYMPTOMS:

Newly created database users works fine, but the old ones that were created before MySQL upgrade cannot connect to it's databases due to password error.

CAUSE:

Most probably the problem is caused by 'mysqld' using new password notation.

RESOLUTION:

Set old_passwords option in /etc/my.cnf in [mysqld] section and restart MySQL:

old_passwords=1

Update passwords for the MySQL users that were created by Plesk in 'mysql' database using the command below:

 echo "select dbu.login, a.password from data_bases db, db_users dbu, accounts a where db.id=dbu.db_id and dbu.account_id=a.id" | mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Ns -Dpsa | awk '{print "update user set Password=password(\x27"$2"\x27) where User=\x27"$1"\x27;"}' | mysql -uadmin -p`cat /etc/psa/.psa.shadow` -Dmysql

Parallels Virtualization and Automation Software

I cannot connect to Mysql database nor from PHP scripts nor from PHPMyAdmin however the password is correct. Only changes - MySQL was upgraded to 4.1 or newer version recently.

RESOLUTION

Please provide feedback on this article