Articles in this section

See more

Is there root user in MySQL on Plesk server?

Avatar
Taras Ermoshin
Updated
Follow

Applicable to:

  • Plesk for Linux
  • Plesk for Windows

Question

Is there a root user in MySQL on a Plesk server?

Answer

MySQL installed and configured with Plesk does not have a user with name root by default. It 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

Sort by Date Votes
  • Avatar
    Unknown User

    When I run the Windows command:

    "%plesk_bin%\\plesksrvclient" -get

    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)"

    0
    Comment actions Permalink
  • Avatar
    Unknown User

    When I run the following command in command line, it throws an error.

    plesk db

    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"

    0
    Comment actions Permalink
  • Avatar
    Artyom Baranov

    @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

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request

Related articles