Articles in this section

See more

Is there root user in MySQL on Plesk server?

Avatar
Nelson Leiva
Updated
Follow
Plesk kb: how-to

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

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