How to register an existing MySQL/MSSQL database in Plesk for Windows?

You may face a situation where you have the MySQL or MSSQL database on servers but not showing in the Plesk Panel at Domains >> Your_domain_name >> Databases.

Please refer to the following steps to register your existing databases on the servers to the Plesk panel. 

  1. Log in to your Windows server via RDP. Please refer to how to connect the windows server via RDP.

  2. Go to the Run and type cmd to open the command prompt.

  3. Run the below command to find-out database servers installed on your server.

    plesk db "SELECT host,port FROM DatabaseServers"
    
  4. Now, run the below command to register the database with your Plesk panel.

    plesk bin database.exe --register db_name -domain
    demovpstest.com -server 173.248.xxx.xxx
  • db_name: Your database name
  • demovpstest.com: Plesk subscription name where the database is going to attach
  • 173.248.xxx.xxx: IP Address of database server
  1. Run the below command to register and attach the database user with your database.

    plesk bin database.exe --register-dbuser db_user -domain
    demovpstest.com -database db_name -user-role readWrite -passwd
    "<password>" -server 173.248.xxx.xxx
  • db_user: Your database username
  • db_name: Your database name
  • password: DB user password
  • 173.248.xxx.xxx: IP Address of database server

Related Articles

Can i use my third-party Plesk license /license key to accuwebhosting VPS /Dedicated Server?

Yes, you can provide us your license key for Plesk in a support ticket. We will add it in your...

How to upload files/folders in Plesk?

We can easily upload files/folders to the Plesk file manager using the upload button or use FTP....

How to add or edit DNS records for a domain in Plesk Control Panel?

This article will guide you on adding or editing DNS records for a domain in Plesk Control Panel....

Can i enable detailed error of my website in Plesk?

When we are writing this article, Plesk doesn't have added any functionality to display detailed...

Cannot access website hosted on Plesk: the server responded with a status of 403 (ModSecurity Action)

If you have hosted your website on Plesk, you may receive the below error.  HTTP Error 403.0 -...

  • 0 Users Found This Useful

Was this answer helpful?