Product:
Search Type:

[How To] How to access Plesk database

Article ID: 3472 
Last Review: Dec,06 2007
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<plesk_admin_password> 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

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields