Sign Up / Log In
Need help?
1 213 559 2459
Online Support Windows Hosting

How to add a MySQL database in Plesk

What is MySQL?

MySQL, or My Structured Query Language, is an open-source database management system where data or information for your website is stored. In order to access data from MySQL, your system needs a computer language such as Java, Perl, Python, and PHP.

Fun fact: The "My" in MySQL is named by Michael Widenius, main author of the original version, after his own daughter's name.

If you are setting up a web-based application, such as a bulletin board, a blog, or an online shop, you will need to set up a MySQL Database to store its web files. Additionally, you will also need to create a Database user in order to gain access to the database you created, which can read, write, or modify data in that database. You can create a database and user within your Plesk panel for Windows Hosting.

How to create a MySQL Database

To create a database in Plesk without a user, follow the steps below:

  1. Click Sign Up / Log In at the top of this page.
  2. Select Hosting Manager from the drop-down menu.
  3. Enter your username and password, then click Log In.
  4. Click Databases from the left-side menu.
  5. Click the + Database button at the top of the page.
  6. Enter a Database name in the field provided.
  7. From the Database server drop-down list, select the server that says default for MySQL.
  8. From the Related site drop-down list, select the website whose files you wish to save in this database.
    Or, select No related sites if you're not ready to connect it to a site yet.

    Note: To assign a website later, go back to Databases from the left-side menu and click the Assign this database to a site link beside the Database name that you wish to manage.

  9. Under Users, deselect Create a database user.
  10. Click OK to save.

Congratulations! You now know how to create a MySQL database in Plesk.

How to add a MySQL User later

To access your database, you will need to create a user. Follow the instructions below to know how:

  1. Go back to Databases from the left-side menu.
  2. Click User Management from the right-side menu.
  3. Click the + Add Database User button at the top of the page.
  4. From the Database server drop-down list, select the server that says default for MySQL.
  5. Enter a Database user name in the field provided, assign a New password for this user, and re-enter the password in the Confirm password field.
  6. Select a Database to connect to this user from the drop-down list provided.
  7. Under Access control, select or deselect the permitted actions you would like to grant the user within the database.
  8. Click OK to save.

Congratulations! You now know how to create a MySQL user in Plesk.

Note: When you create a database and/or user, the system will automatically use your Plesk panel username as a prefix, e.g., username_database01 or username_user01.

To further manage the user priveleges assigned to the Database user you just created, go back to Databases from the left-side menu, click User Management from the right-side menu, and click on the Database user name that you wish to manage. You will be able to manage the user's Role, Data Access privileges, and Structure Access priviliges from here.

Was this helpful? Yes No 100% of people found this helpful.
we're
online
Need Help? Chat Now