Applicable to:
- Plesk 17.8 for Windows
Symptoms
-
It is not possible to access Plesk SQL server on port 8306 using the Plesk admin password in Plesk Onyx 17.8 on Windows Server:
C:\> "%plesk_dir%\MySQL\bin\mysql" -uadmin -p -P8306 psa
Enter password: ********
ERROR 1045 (28000): Access denied for user 'admin'@'localhost' (using password: YES) - It is possible to log in to Plesk using the Plesk admin credentials.
Cause
This is the expected behavior. For security purpose, the Plesk admin and psa database admin passwords are different since Plesk Onyx 17.8. During the upgrade procedure, Plesk database admin password is being generated randomly.
Resolution
Use the "plesk db" utility to access Plesk SQL server (psa database):
-
Connect to a Plesk server via RDP.
-
Start a command prompt as an Administartor.
-
Run the command:
C:\> plesk db
Comments
4 comments
So, how can we learn new password of Plesk to access psa database from HeidiSQL?
Hello, @omer.
For Windows, use psadb.exe utility as described in the following article:
How to retrieve administrator's Plesk database password on Plesk 17.8 for Windows?
P.S. For linux, just use the content of /etc/psa/.psa.shadow file, this hash can work in the same manner as a plain text password.
Thanks for your reply,
I use Windows Server 2012 R2 and Plesk Onyx 17.8.11
Yes I know that page, but I want to access psa database from another tool. Such as HeidiSQL. Is it possible to access psa database from HeidiSQL?
@omer
Yes, it is possible to connect to Plesk database using HeidiSQL
Please sign in to leave a comment.