Starting on October 19, 2021, we will enable 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.
To be prepared for this change and to avoid the need to register during your next ticket submission after the change, we encourage you to create an account here before October 19 using the same email address as your current 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. You will continue to use ZenDesk authentication until we switch over to single-sign-on on October 19th.

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

Follow

Comments

2 comments

  • Avatar
    Sathiya

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

    0
    Comment actions Permalink
  • 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

Please sign in to leave a comment.

Have more questions? Submit a request