Access to Plesk and database is possible, but the following errors occur:
When performing any changes in Plesk or the Plesk database:
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
When performing a Plesk upgrade:
MySQL databases are dumped to /var/lib/psa/dumps/mysql.preupgrade.9.5.4-188.8.131.5230807.dump.gz. ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES)
A reinstalled or broken MySQL server.
For Windows see article 213388329 "ERROR PleskMainDBException Access denied for user 'admin'@'localhost' (using password: YES)"
- Make sure that the password for the admin user is set correctly using the following article for Linux: 213927525 "How to retrieve Plesk admin password on Linux"
Make sure that the
adminuser has all privileges:
Log into MySQL server under 'root':
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin mysql
Check admin privileges:
mysql> SHOW GRANTS FOR 'admin'@'localhost'\G
Grant all privileges to
GRANT ALL ON *.* TO 'admin'@'localhost' WITH GRANT OPTION;
If the steps above will not help, or the previous command fails with an error, check
If you see a message such as:
[ERROR] Missing system table mysql.proxies_priv; please run mysql_upgrade to create it
this probably means that MySQL was reinstalled or was not upgraded completely. Run the following command to update MySQL:
# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql_upgrade -uadmin