How to Create/Remove MySQL or MS SQL Database in Plesk

How to create MySQL Database in Plesk

1. Login to your Plesk control Panel.
2. From Website & Domains Tab click Add Database Button.

   
   
   

3. From the Add a Database Page type the following:
   1. Database name: type your unique database name.
   2. Database server : for MySQL Server select MySQL from drop down list.
   3. Related site: choose the domain that your database related to,it can be also any subdomains you have in your hosting account too.
   4. Users: create users associated with your database:
      1. Create a database user:Tick to create the database user immediately .
      2. Database user name:type unique database username.
      3. New password: type strong password.
      4. Confirm password:Re-type the new password.
      5. User has access to all databases within the selected subscription :if you enable this option this will allow the current new user to access all database related to your subscription.
      6. Access control :
         1. Allow local connections only. Select to allow access from all Plesk’s IP addresses. These include the localhost and all other IP addresses used by Plesk.
         2. Allow remote connections from any host. Select to allow access from any server, including the localhost and IP addresses of the Plesk server.
         3. Allow remote connections from (the specified hosts). Select to allow access from the specified host names or IP addresses. Note that local connections will be allowed too.
4. Click Ok button to create the new MySQL database and the new user.

   
   

How to create MS SQL Database in Plesk

1. Login to your Plesk control Panel.
2. From Website & Domains Tab click Add Database Button.
3. From the Add a Database Page type the following:
   1. Database name: type your unique database name.
   2. Database server : Select MS SQL from drop down list.
   3. Related site: choose the domain that your database related to.
   4. Users: create users associated with your database:
      1. Create a database user:Tick to create the database user immediately .
      2. Database user name:type unique database username.
      3. New password: type strong password.
      4. Confirm password:Re-type the new password.
      5. User has access to all databases within the selected subscription :if you enable this option this will allow the current new user to access all database related to your subscription.
4. Click Ok button.

How to remove Databases in Plesk

1. Login to your Plesk control panel.
2. Click Databases Tab , you will see the list of your databases including “MySQL or MS SQL” database engines.
3. Select your database you want to remove and Click Remove Database.