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

0

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.

Log in to your Windows server via RDP. Please refer to how to connect the windows server via RDP.
Go to the Run and type cmd to open the command prompt.
Run the below command to find-out database servers installed on your server.
```
plesk db "SELECT host,port FROM DatabaseServers"
```

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

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

Get Windows VPS

Was this answer helpful?

Related Articles

How to Assign Permissions to Files and Folders in Plesk Control Panel? In Plesk, adjusting file and folder permissions lets you decide who can see your files and what... How to Blacklist a Domain in Plesk? At some point in managing your email server, you may encounter the need to blacklist a domain in... How to enable automatic backups in Plesk Control Panel? Login to the Plesk panel with the username and password: 1. The URL of the Plesk control panel... How to add domain and subdomain in Plesk Control Panel? This article will guide you on how to add domains and sub domains in Plesk Control Panel. Step:... How to create MSSQL database using Plesk? Please refer to the following steps to create an MSSQL database from Plesk. Log in to your...