Results 1 to 3 of 3

Thread: MySQL root password

  1. #1
    Bit Poster
    Join Date
    Feb 2013
    Posts
    1

    Default MySQL root password

    Dear All,
    I am new to plesk and have been given assignment to work on it. I even don't know the version on plesk installed on the server. I have written shell script that takes the MySQL database backup but I don't know root password. Can you please help me to get root password so that I can test my shell script? I even can't login to MySQL using user 'admin' and same password as plesk panel. PLease guide me about it and I will be thankful to you guys.



  2. #2
    Parallels Team IgorG's Avatar
    Join Date
    Oct 2009
    Location
    Novosibirsk, Russia
    Posts
    15,620

    Default

    During Plesk installation procedure root mysql account will be renamed to admin. So you can login to mysql with following command:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow`
    -
    Plesk Service Team || Twitter Facebook RSS



  3. #3
    Mega Poster
    Join Date
    Jan 2011
    Posts
    116

    Default

    Quote Originally Posted by ZaeemS View Post
    I even can't login to MySQL using user 'admin' and same password as plesk panel.
    I have exactly the same problem. Any solutions?

    I already set the Plesk password again, but the MySQL root (admin) PW ist still not the same as the Plesk PW.

    I can access the DB via the Plesk phpMyAdmin, but if I access it manually (seperate installation of phpMyAdmin), it does not work.

    Edit: mysql -uadmin -p`cat /etc/psa/.psa.shadow` works, how is this possible?

    I need to backup my databases automatically and I need to set the PW in my script.

    Edit 2: I solved the problem for the moment by creating a new user with all privileges. I use this user now for my own phpMyAdmin installation and my backup scripts.
    Last edited by King555; Mar 18, 2013 at 03:18 PM.



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •