What password should be used to connect to MySQL database?

Refers to:

  • Plesk 12.5 for Linux
  • Plesk 11.0 for Linux
  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:45:36 UTC

Modified:

2017-02-14 12:08:50 UTC

1

Was this article helpful?


Have more questions?

Submit a request

What password should be used to connect to MySQL database?

Symptoms

The following error occurs trying to use Plesk admin password to create MySQL dump:

mysqldump: Got error: 1045: Access denied for user 'admin'@'localhost' (using password: YES) when trying to connect

Cause

Plesk uses encrypted password to connect to the database.

Resolution

Password is stored in the following file:

# cat /etc/psa/.psa.shadow
$AES-128-CBC$XIhAAAAAAAAAA+tw==$85FWOUmg8AAAAAAAAAg==

Use the following command to make a database dump:

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > /root/psa.`date +%F`
Have more questions? Submit a request
Please sign in to leave a comment.