How to access the Plesk psa database in MySQL/MariaDB

• To access Plesk database in MySQL/MariaDB:

  [root@server]# plesk db

  Once you are logged in, start running SQL queries.

  Example of an SQL query:

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

  To exit MySQL/MariaDB, run the command:

  mysql> quit

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

  [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 |
  +----+-------------+

On Windows Server, Plesk uses two MySQL/MariaDB 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

• 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 |
    +----+-------------+

Accessing MySQL/MariaDB server

• Run the following command:

  C:> "%plesk_dir%MySQLbinmysql" -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/MariaDB 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: