How to access psa database in Plesk Server

We can access plesk psa database, from the Linux command line (via ssh) and from the Plesk control panel.

The /etc/psa/.psa.shadow file contains the Plesk admin password.

So to access the database run the following command.

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

Select the psa database.

mysql> use psa;

To view all the tables

mysql> show tables;

Trackback URI | Comments RSS

Leave a Reply

You must be logged in to post a comment.