1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

How to find root password of Plesk for MySQL 5

Discussion in 'Plesk for Linux - 8.x and Older' started by cpartassides, Jul 3, 2008.

  1. cpartassides

    cpartassides New Pleskian

    22
    73%
    Joined:
    Jul 3, 2008
    Messages:
    18
    Likes Received:
    0
    Windows Plesk 8.3 is provided to me by my server provider also.

    I would like to have root access to the MySQL 5 which is installed.

    My question is : How do i find the root password for it - i am guessing the one Plesk is using also to authenticate itself to mysql 5 for administrating databases. How can i update this password for plesk ?

    thanks

    Costas P.
     
  2. Cheatah@

    Cheatah@ Guest

    0
     
    See /etc/psa/.psa.shadow
    If you don't have access there, you can still set a new admin password in the control panel if you have sufficient permissons.
     
  3. cpartassides

    cpartassides New Pleskian

    22
    73%
    Joined:
    Jul 3, 2008
    Messages:
    18
    Likes Received:
    0
    i thought i posted this inside the windows forum :)

    anyone knows what to do for windows ?

    thanks
     
  4. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Upgrade it to linux.
     
  5. eugenevdm

    eugenevdm Silver Pleskian

    30
    68%
    Joined:
    Nov 11, 2003
    Messages:
    611
    Likes Received:
    0
    Huh?

    Atomic, I love you but the correct answer is:

    "Look in PSA db in misc table there are mysql_admin and mysql_password values."
     
  6. atomicturtle

    atomicturtle Golden Pleskian

    29
     
    Joined:
    Nov 20, 2002
    Messages:
    2,110
    Likes Received:
    7
    Location:
    Washington, DC
    Heh, I'm going to let you think about the futility of that approach :p
     
  7. Brian H

    Brian H New Pleskian

    19
    35%
    Joined:
    Jan 27, 2010
    Messages:
    6
    Likes Received:
    0
    This is an old thread, but for anyone still looking for a solution here, eugenevdm was correct. Remember that there are TWO mySQL instances on a plesk server. The plesk PSA MySQL instance, which uses your Plesk admin creds as username/password, which is what eugenevdm is recommending you connect to. Then look in the "databaseservers" table and you will see plaintext username/password for the other MYSQL Instance, the "user" instance. The User instance is probably where most people are trying to gain root access too, and is where all user databases are stored.

    So I think that atomicturtle is confusing the two databases. Most users should be able to connect to their Plesk MySQL isntance, likely on port 8306, get the root creds for the user instance, and then connect to their USER mysql instance on port 3306.
     
Loading...