Plesk installation fails with the error: "Access denied for user: 'root@localhost'".

Created:

2016-11-16 13:25:52 UTC

Modified:

2017-04-24 11:33:36 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Plesk installation fails with the error: "Access denied for user: 'root@localhost'".

Applicable to:

  • Plesk 11.5 for Windows
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Windows
  • Plesk 12.0 for Linux

Symptoms

Plesk installation fails with the error:

 Trying to connect with admin:setup account... ERROR 1045: Access denied for user: 'admin@localhost' (Using password: YES)
not connected
Trying to connect as root with empty password... ERROR 1045: Access denied for user: 'root@localhost' (Using password: NO)
not connected Cannot connect to mysql database.

Resolution

Normally for Plesk installation, MySQL administrator must be 'root' user with the empty password. If you know current 'root' MySQL password, please login with it and continue with the query from the step 2. If you do not know the password, begin from the step 1:

1.Add the 'skip-grant-tables' option into /etc/my.cnf (for Debian-like systems the file is /etc/mysql/my.cnf) in '[mysqld]' section and restart MySQL:

  1. Set the empty password for MySQL 'root' user: # mysql -uroot -Dmysql -e 'update user set password="" where user="root"'
  2. Comment out or remove string 'skip-grant-tables' in /etc/my.cnf and restart MySQL.

  3. Try to install Plesk again.

Also check the article about Plesk admin password recovery .

Have more questions? Submit a request
Please sign in to leave a comment.