This article provides instructions to add a database with an associated database user to one of your domains on your (dv) Dedicated-Virtual Server 4.0.

Instructions

1. Log into the Plesk Control Panel for your domain. See Figure 1:

   
   Figure 1. The Plesk Control Panel. Click for a larger view.

   If you log into Plesk with the admin user, you will be in the Server Administration Panel by default. To get to the Control Panel, click on Domains, then on the Control Panel link next to your domain.

   You can also create a user that will log into the Control Panel by default, which will save you a few clicks on day-to-day webmaster tasks. See Control Panel user.

2. From the Home page, click on Websites & Domains. See Figure 2:

   
   Figure 2: Click on the "Websites & Domains" tab.

3. Click on Show Advanced Options. See Figure 3 for the location of this link.

   
   Figure 3: Click on "Show Advanced Options" for an additional menu.

4. Next, click on Databases. See Figure 4:

   
   Figure 4: Click "Databases" to begin.

5. Click on Add New Database. See Figure 5:

   
   Figure 5: Click "Add New Database" to begin.

6. Complete the form by entering your desired database name and then click the OK button. See Figure 6:

   
   Figure 6: Use any name for your database that you can easily recognize its purpose.

7. You will receive a message that the database was successfully created. See Figure 7:

   
   Figure 7: A sample "success" message.

8. Now, we'll create a database user. Click on Add New Database User. See Figure 8:

   
   Figure 8: Click the icon to begin.

9. Complete the form and click the OK button. See Figure 9:

   
   Figure 9: Click the "OK" button to continue.

10. That's it. You have successfully created a database and a user for that database.

Now, you may want to import a database to your new server. See this article for instructions: Export and import MySQL databases.

This article provides instructions to add a database with an associated database user to one of your domains on your (dv) Dedicated-Virtual Server.

Instructions

1. Log into Plesk.
2. Click on Domains on the left.

   

3. Click on your domain.
4. Click on Databases.

   

5. Click on Add New Database.

   

6. Fill in the details for the database, then click OK.
   • Database name: What you want to call your database.
   • Type: MySQL is available by default.
   • Database server: The Local MySQL server is available by default.

   

7. Now, click Add New Database User.

   

8. Fill in your user details, then click OK:
   • Database user name: The username for accessing this database.
   • Old password: None.
   • New password: The password for accessing this database.
   • Confirm password: Type the same password.

   

9. Now, you can access phpMyAdmin for this database, if you want to. Click on DB WebAdmin. You may have to enable popups in your browser for this site.

   

10. You also now have all of the necessary information for your database connection script and/or CMS:
    • Host: localhost
    • Database name: The database name you created in Step 5.
    • Username: The username you created in Step 7.
    • Password: The password you created in Step 7.