How to access Plesk database?
Posted: Thu Mar 22, 2012 1:02 am
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.
You will be connected to the Mysql server. To use psa database, execute following command.
To view all the psa database tables:
Here is how you could access it.
Code: Select all
mysql -uadmin -p`cat /etc/psa/.psa.shadow`Code: Select all
mysql> use psa;Code: Select all
mysql> show tables;