{"id":991,"date":"2010-07-17T04:28:51","date_gmt":"2010-07-17T08:28:51","guid":{"rendered":"http:\/\/linuxhostingsupport.net\/blog\/?p=991"},"modified":"2013-03-20T08:43:17","modified_gmt":"2013-03-20T12:43:17","slug":"how-to-access-psa-database-in-plesk","status":"publish","type":"post","link":"https:\/\/linuxhostingsupport.net\/blog\/how-to-access-psa-database-in-plesk","title":{"rendered":"How to access psa database in Plesk?"},"content":{"rendered":"

Plesk uses a ‘psa’ database to store all the data and values.<\/strong> This data can be easily retrieved at any point of time using the Mysql queries.<\/p>\n

How to access the Plesk ‘psa’ database in Linux?<\/strong>
\nThere are 2 ways, one via SSH (Linux command line) and the other from the Plesk control panel.<\/p>\n

Method 1) <\/strong><\/p>\n

<\/strong>SSH to your server as root and execute the following command. The \/etc\/psa\/.psa.shadow file contains the Plesk admin password.<\/p>\n

\n
# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/span><\/pre>\n<\/blockquote>\n
You will be connected to the Mysql server. To use psa database, execute<\/p>\n
\n
mysql> use psa;<\/span><\/pre>\n<\/blockquote>\n
To view all the psa database tables:<\/p>\n
\n
mysql> show tables;<\/span><\/pre>\n<\/blockquote>\n
Method 2)<\/strong><\/p>\n
Login to the Plesk control panel as user admin<\/p>\n
\n
Goto Settings -> Database Hosting Preferences -> click OK -> <\/span><\/pre>\n
Local MySQL server -> Databases tab -> click Webadmin.<\/span><\/pre>\n<\/blockquote>\n
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.<\/p>\n","protected":false},"excerpt":{"rendered":"
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.
\nHow to access the Plesk ‘psa’ database in Linux?
\nThere are 2 ways, one via SSH (Linux command line) and the other from the Plesk control panel.
\nMethod 1)
\nSSH to your server as root and execute the following command. The \/etc\/psa\/.psa.shadow file contains the Plesk admin password.<\/p>\n
# mysql -uadmin -p`cat \/etc\/psa\/.psa.shadow`<\/p>\n
You will be connected to the Mysql server. To use psa database, execute<\/p>\n
mysql> […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[967,970,968,966,964,971,965,969],"_links":{"self":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/991"}],"collection":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/comments?post=991"}],"version-history":[{"count":8,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/991\/revisions"}],"predecessor-version":[{"id":2233,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/posts\/991\/revisions\/2233"}],"wp:attachment":[{"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/media?parent=991"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/categories?post=991"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/linuxhostingsupport.net\/blog\/wp-json\/wp\/v2\/tags?post=991"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}