How to access the Plesk psa database in MySQL

In Plesk Onyx/Plesk 12.x, use the plesk db utility:

• To access Plesk database in MySQL:

  [root@server]# plesk db

  Once you are logged in, start running SQL queries.

  Example of an SQL query:

  MYSQL_LIN: mysql> select id,name from domains where name='example.com';
  +----+-------------+
  | id | name        |
  +----+-------------+
  | 3  | example.com |
  +----+-------------+

  To exit MySQL, run the command:

  MYSQL_LIN: mysql> quit

• To run a query to Plesk database without logging in to MySQL:

  [root@server]# plesk db "your_query_here"

  Example:

  [root@server]# plesk db "select id,name from domains where name='example.com'"
  +----+-------------+
  | id | name        |
  +----+-------------+
  | 3  | example.com |
  +----+-------------+

In Plesk 11.x and previous releases, use the following command:

• To access Plesk database in MySQL:

  [root@server]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa

• To run a query to Plesk database without logging in to MySQL:

  [root@server]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa -e "select * from <table>"

On Windows Server, Plesk uses two MySQL instances:

• Plesk SQL Server on port 8306: for Plesk databases psa and apsc
• MySQL server on port 3306: for Horde, Sitebuilder and customers' databases

Accessing Plesk SQL Server

• On Plesk Onyx/Plesk 12.5, use the plesk db utility:

  • To access Plesk database in MySQL:

    C:\> plesk db

    Once you are logged in, start running SQL queries.

    Example of an SQL query:

    C:\> mysql> select id,name from domains where name='example.com';
    +----+-------------+
    | id | name        |
    +----+-------------+
    | 3  | example.com |
    +----+-------------+

    To exit MySQL, run the command:

    C:\> mysql> quit

     

  • To run a query to Plesk database without logging in to MySQL:

    C:\> plesk db "your_query_here"

    Example:

    C:\> plesk db "select id,name from domains where name='example.com'"
    +----+-------------+
    | id | name        |
    +----+-------------+
    | 3  | example.com |
    +----+-------------+

• In Plesk 12.0/Plesk 11.x and previous releases, use the following command:

  • To access Plesk database in MySQL:

    C:\> "%plesk_dir%\MySQL\bin\mysql" -P8306 -uadmin -p psa

  • To run a query to Plesk database without logging in to MySQL:

    C:\> "%plesk_bin%\dbclient" --direct-sql --sql="select * from <table>"

Accessing MySQL server

• Run the following command:

  C:\> "%plesk_dir%\MySQL\bin\mysql" -P3306 -uadmin -p

  If the password is unknown, reset it according to this KB article.

1. In Plesk, go to Tools & Settings > Database Servers > select MySQL server running on port 3306 > click on the  icon:

   Click on the picture to enlarge
   
   

2. Select Plesk database "psa" from the list:

   
   
   
   

3. Switch to the SQL tab:

   
   
   
   

4. Type in an SQL query and click Go to execute it: