On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

How to unlink databases from Plesk without removing it from the server?

Follow

Comments

2 comments

  • Avatar
    Alexandr Redikultsev (Edited )

    Hi, @Sathiya.

    It should be showing all the databases registered in Plesk, MySQL, PostgreSQL and MS SQL. it is possible to alter the query to show the database server type like this:

    C:\> mysql> SELECT db.id AS DB_ID,db.name,dbu.id AS DB_USR_ID,dbu.login,d.name AS Domain, db.type as Type FROM data_bases db JOIN db_users dbu ON db.id = dbu.db_id LEFT JOIN domains d ON db.dom_id = d.id;
    +-------+-----------+-----------+----------+-------------+-------+
    | DB_ID | name     | DB_USR_ID | login      | Domain | Type      |
    +-------+-----------+-----------+----------+-------------+-------+
    | 1     | mysql_db | 1         | usr1  | example.com | mysql     |
    | 2     | mssql_db | 2         | usr2  | example.com | mssql     |
    +-------+-----------+-----------+----------+-------------+-------+
    2 rows in set (0.00 sec)

    1
    Comment actions Permalink
  • Avatar
    Sathiya

    This script is not showing MSSQL databases list. is it only for MySQL

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request