Applicable to:
- Plesk for Linux
- Plesk for Windows
Question
Is there a root user in MySQL in Plesk?
Answer
MySQL installed and configured with Plesk does not have a user with name 'root' by default. It is renamed to 'admin' and have only 'localhost' access. On Linux, password is encrypted and stored in /etc/psa/.psa.shadow, on Windows, it is in Windows Registry.
Plesk for Windows has two different MySQL instances with different 'admin' users.
Additional information about access to the MySQL instances and other database servers can be found in:
How to access Plesk database How to retrieve/reset a password of the "admin" user in Plesk for Linux
How to retrieve/reset a password of the "admin" user in Plesk for Windows
Comments
3 comments
When I run the Windows command:
I get an error. It states:
"Access is denied. (Error code 5) at Unable to connect to pipe \\.\pipe\P_b0648554-d2c0-47c2-8509-fbedf7f0ba6c at (Con::ClientOverlappedPipe::create line 503) at get(wWinMain line 164)"
When I run the following command in command line, it throws an error.
Throws:
"Unable to get database admin password: exit status 1 ERROR 1045 <28000>: Access denied for user 'admin'@'localhost' (using password NO)
exit status 1"
@Rob Simpson,
Hi! That is because the command-line tool was not launched with administrative privileges.
Open command line (cmd.exe) as administrator (right click on "command prompt"->"run as administrator") and execute "plesk db" again: https://goo.gl/B7WLgs
Please sign in to leave a comment.