Plesk uses a ‘psa’ database to store all the data and values. This data can be easily retrieved at any point of time using the Mysql queries.
How to access the psa database in Plesk?
There are 2 ways to access the Plesk psa database, from the Linux command line (via ssh) and from the Plesk control panel.
Method 1) To access the psa database from command line:
SSH to your server as root. and execute the mysql command. The /etc/psa/.psa.shadow file contains the Plesk admin password.
# mysql -uadmin -p`cat /etc/psa/.psa.shadow`
You will be taken to the Mysql prompt. To switch to the psa database, execute,
mysql> use psa;
You are now in the psa database and can view all the tables
mysql> show tables;
Method 2) From the Plesk control panel.
Login to Plesk as user ‘admin’ and password from /etc/psa/.psa.shadow file.
Click "Settings" >> "Database Hosting Preferences" >> click OK >>
"Local MySQL server" >> "Databases" tab >> "Webadmin".
Once you click “Webadmin”, phpMyAdmin will open in a new window from where you can access all the databases including the ‘psa’ database. Make sure pop-ups are enabled in your browser.
Tags: access mysql command prompt in plesk, different ways of accessing psa database, different ways to access psa database in plesk, how to access mysql on a plesk server?, how to access psa database?, phpmyadmin and psa database, various ways to access psa database, where is the plesk admin password stored?