How to access the Plesk psa database in MySQL/MariaDB

Dmitry Bystrov

3 months ago

Question

How to connect to MySQL/MariaDB and open the Plesk psa database?

Answer

Note: This guide is intended for Plesk administrators with SSH/RDP access to the server.

Accessing Plesk database on Linux via SSH

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

Accessing Plesk database on Windows Server via RDP

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.

Accessing Plesk database in Plesk interface on Linux

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
Select Plesk database "psa" from the list:
Switch to the SQL tab:
Type in an SQL query and click Go to execute it:

0 Shares

Exit mobile version