Creating A MySQL Database In cPanel

This step-by-step guide will give you instructions on how to create a MySQL database in cPanel.

Step 1:
Scroll down to the “Databases” section.

Step 2:
Click the “MySQL Databases” icon.

Step 3:
Enter a name for the database.

Note: The database name you enter will be automatically prefixed with your cPanel username and an underscore (“_”). This is to prevent database name collisions with other users’ databases on a server.

Step 4:
Click the “Create Database” button.

The database has been created! Before you can use it, you must create and add a user to the database.

Note: You can use your cPanel username and password to access any database with a script, but this is undesirable for several reasons, not the least of which is the fact that your script will abruptly stop working the moment you change your cPanel password. It is also a security risk as most scripts store database passwords in plain text.

Step 1:
Click the “Go Back” link.

Step 2:
Scroll down to the “MySQL User” section.

Step 3:
Enter a username for the new MySQL user.

Step 4:
Enter a password for the user.

Note: You may also use the “Generate Password” button. It will automatically create a maximum strength password for you.

Step 5:
Re-enter the password to confirm.

Step 6:
Click the “Create User” button.

Your new MySQL user has been created. The final step is to give the user access to the database.

Step 1:
Click the “Go Back” link.

Step 2:
Scroll down to the “Add User To Database” section.

Step 3:
Select the appropriate user and database pair.

Step 4:
Click the “Add” button.

Step 5:
Click the “All Privileges” check box.

Step 6:
Click the “Make Changes” button.

Congrats! You now know how to create a MySQL database in cPanel.

Tagged cpanel, creating a database in mysql, creating a database mysql, creating a database with mysql, creating a mysql database, creating a new database in mysql, creating a table in mysql database, mysql creating a database, mysql database in cpanel