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:

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

1. In Plesk, go to Tools & Settings > Database Servers > select MySQL server running on port 3306 &gt…