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 Wizard2. 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
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.
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 privileges6. 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 area.2. Enter a name for the database. Click “Create Database” then “Go Back”.Create a new database3. Navigate to “MySQL Users” then “Add New Users”4. Create new user credentials including Username and password. 5. Click “Create User” then “Go Back”.
Create a MySQL user
6. Navigate to “Add User To Database”.7. Select the User & the Database you want them to have permissions for.
Add cPanel users to a database
8. Configure the user’s permissions. 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”.
The Plesk admin sidebar
3. Click “Add a Database”.
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.Configure database in Plesk
You can also enable that the created user can manage any database within the subscription. (Useful if you manage multiple databases)
