How to access Plesk database

APPLIES TO:

  • Plesk for Windows

Answer

Plesk Database can be accessed by following steps below depending on the database provider are configured in current Plesk installation.

For MSSQL provider:

Database can be accessed using the following CLI command:

C:\Program Files\Microsoft SQL Server\80\Tools\Binn\osql –E

Or Microsoft SQL Server Management Studio Express utility can be used.

For MySQL DB provider:

Execute the following commands in command prompt:

cd %plesk_dir%\Databases\MySQL\bin


mysql -P8306 -uadmin -p psa

For MS Access DB provider (JET):

You can find and use any utility for viewing MS Access(.mdb) database files:

E.g.

http://www.alexnolan.net/software/mdb_viewer_plus.htm


http://www.softpedia.com/get/Internet/Servers/Database-Utils/MDB-View.shtml

Plesk Database file is located in %plesk_dir%\admin\db\psa.mdb

Leave a comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.