How to access psa database in Plesk?

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 Plesk ‘psa’ database in Linux?
There are 2 ways, one via SSH (Linux command line) and the other from the Plesk control panel.

Method 1)

SSH to your server as root and execute the following command. The /etc/psa/.psa.shadow file contains the Plesk admin password.

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

You will be connected to the Mysql server. To use psa database, execute

mysql> use psa;

To view all the psa database tables:

mysql> show tables;

Method 2)

Login to the Plesk control panel as user admin

Goto Settings -> Database Hosting Preferences -> click OK -> 
Local MySQL server -> Databases tab -> click 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.

This entry was posted on Saturday, July 17th, 2010 and is filed under Plesk Management. You can follow any responses to this entry through the RSS 2.0 feed. Both comments and pings are currently closed.

Comments are closed.