Question
How to connect to MySQL and open the Plesk psa database?
Answer
Note: This guide is intended for Plesk administrators with SSH/RDP access to the server.
In Plesk Onyx/Plesk 12.x, use the plesk db
utility:
-
To access Plesk database in MySQL:
[[email protected]]# 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, run the command:
mysql> quit
-
To run a query to Plesk database without logging in to MySQL:
[[email protected]]# plesk db "your_query_here"
Example:
[[email protected]]# 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:
[[email protected]]# MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa
-
To run a query to Plesk database without logging in to MySQL:
[[email protected]]# 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%MySQLbinmysql" -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%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 server running on port 3306 >…