How to access MySQL without knowing its password in a Plesk server

Here I am explaining how you can access MySQL without knowing its password in a Plesk server.

# mysql -uadmin -p`cat /etc/psa/.psa.shadow`

The above command is used to access MySQL without prompting for a password.

In case, if you need to take backup of a database or you need to restore a database in a plesk server and you don’t know the MySQL root password, then you can follow the steps below:

# mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` database_name > database.sql

# mysql -uadmin -p`cat /etc/psa/.psa.shadow` database_name < database.sql

That’s it!!

Related Links:
Reset mysql root password from command line
How to allow mysql client to access remote mysql databases

Post navigation

Arunlal Ashok

Linux Systems Architect at Endurance International Group. I know her (Linux) since many years. Linux lover. Like to play on Linux console. I started this blog to share and discuss Linux thoughts.

Always happy for an open discussion! Write to arun (@) crybit (dot) com. Check about me for more details. About this blog and our strong members, check The team

Leave a Reply

Your email address will not be published. Required fields are marked *