Article ID: 1758, created on Mar 26, 2007, last review on Jun 17, 2016

  • Applies to:
  • Plesk for Linux/Unix


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.


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


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


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 and" |  MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -uadmin -Ns -Dpsa | awk '{print "update user set Password=password(\x27"$2"\x27) where User=\x27"$1"\x27;"}' |  MYSQL_PWD=`cat /etc/psa/.psa.shadow`  mysql -uadmin -Dmysql

29d1e90fd304f01e6420fbe60f66f838 a914db3fdc7a53ddcfd1b2db8f5a1b9c 56797cefb1efc9130f7c48a7d1db0f0c

Email subscription for changes to this article
Save as PDF