Create a MySQL database

MySQL is a relational database management system or RDBMS. Within cPanel, MySQL supports backend operation by allowing authorized access and manipulation of a database through SQL queries.

Firstly, without a database, content management system-type applications could not function. These applications include WordPress, Drupal, and Joomla. This is because, databases are a critical element in LAMP-style servers (Linux, Apache, MySQL, and PHP). 

When trying to create a MySQL database in cPanel, we recommend using the pre-packaged MySQL wizard. It provides a beginner-friendly database creation guide, ensuring the correct configuration of new databases. With a user-specific database prefix and an assigned user with configurable permissions.

Both cPanel and Plesk allow you to manually create a MySQL database. Although not as beginner-friendly as the cPanel MySQL Wizard, neither of these are overly technical. And, they provide access to extended features, including the checking and repair of an existing database.

cPanel also supports the viewing and manipulation of individual databases and their tables through phpMyAdmin. If you’re a WordPress user, you may also benefit from our WordPress backup guide.

For WordPress, it is especially vital that the database prefix, table prefix and database user credentials are correct. These values are critical to WordPress since without these values the front and backend are not “tied together”. Thus, explaining why any incorrect configuration will cause the “Error establishing a database connection” or other error messages to appear.

MySQL Wizard

1. Firstly, if you want to use the MySQL Wizard, login to your cPanel control panel, from here you can select the “MySQL® Database Wizard” in the “Databases” section.

cPanel MySQL Wizard
cPanel MySQL Wizard

2. Once you have clicked the wizard, enter a name for your database. However, notice that the prefix is already set and cannot be changed.

Create a new database with the cPanel MySQL Wizard
Create a new database

3. Enter a username and password for your database user. Similarly, you can see that the username prefix is already set and cannot be changed.

Creating a database user with the cPanel  the MySQL Wizard
Create a database user

4. To secure the account we recommend using the password generator. This is because the generator creates a unique password.

cPanel Password Generator

5. Now you have made a user, you need to assign permissions. In most cases, you will select all. However, sometimes you need to restrict access for certain users.

Configure user privileges in cPanel MySQL Wizard
Configure user privileges

6. You have completed the setup. From here you can choose to add additional databases, and users or return to your cPanel control panel.

Create a MySQL Database Manually in cPanel

1. For manual setup, continue to step one in the cPanel Wizard guide above. Instead of clicking the wizard. Click “MySQL® Databases” in the “Databases” section. 

cPanel MySQL Databases
cPanel MySQL databases area.

2. Enter a name for the database. Click “Create Database” then “Go Back”.

Manually create a database in cPanel
Create a new database

3. Navigate to “MySQL Users” then “Add New Users”

4. Create new user credentials including Username and password. 

5. Click “Create User” then “Go Back”. 

Manually create MySQL users in cPanel
Create a MySQL user

6. Navigate to “Add User To Database”

7. Select the User & the Database you want them to have permissions for.

Manually add cPanel users to database
Add cPanel users to a database

8. Configure the user’s permissions.   

Configure user privileges in cPanel MySQL Wizard
Configure user privileges

Create a MySQL Database in Plesk

1. Log in to your Plesk control panel.

2. Navigate to the right sidebar and click “Databases”

Plesk admin area sidebar.
The Plesk admin sidebar

3. Click “Add a Database”.

Add a database in Plesk
Plesk database tool

4. Enter a database name. Select a related site (If applicable). Tick “Create a database user” then Enter user information for your database.

Add a database tool with configuration options.
Configure database in Plesk

[custom_alert type=”primary”]You can also enable that the created user can manage any database within the subscription. (Useful if you manage multiple databases)[/custom_alert]