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.
-
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 dbutility:-
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.
-
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:
with