How to access Plesk database?

[Saman]

Plesk database is named as psa and stored in the same MySQL server. There are some situations where you need to manually change the settings especially after an update of Plesk panel which ends up with errors due to bugs in update script.

Here is how you could access it.

Code: Select all

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

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

Code: Select all

mysql> use psa;

To view all the psa database tables:

Code: Select all

mysql> show tables;