Feb 24, 2013, 08:10 AM
MySQL root password
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.
Feb 25, 2013, 12:29 AM
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`
Mar 18, 2013, 03:10 PM
I have exactly the same problem. Any solutions?
Originally Posted by ZaeemS
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 04:18 PM.