Plesk
kb: how-to
ABT: Group B
Applicable to:
- Plesk
Question
Is there a root user in MySQL on a Plesk server?
Answer
Yes. MySQL installed with Plesk has different root
users which are used for administrative tasks such as log rotation.
The main user for MySQL in Plesk is renamed to admin
and has access only to localhost.
-
On Plesk for Linux, the password of the user admin is encrypted and stored in
/etc/psa/.psa.shadow
. -
On Windows, the password is stored in Windows Registry. Plesk for Windows has two different MySQL instances with different admin users.
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.