How to Create MySQL Database in Cpanel

A MySQL database is an organized collection of data, stored and accessed electronically from a computer system. A MySQL user is a record on the MySQL server that exists for authentication. It is separate from the usernames you use to log into Windows or even into cPanel/WHM. Separate MySQL users make your website’s databases more secure, because you can assign permissions to each user. Apart from you, the website’s owner, no user should get full access to your database.

After you create the database, you need to create a user and assign privileges to it. MySQL user accounts are created separately from mail and web administrator accounts.

Create or Delete a MySQL Database

• Create a MySQL Database

1. Log into cPanel and locate Databases.
2. Click MySQL Databases.
3. In the New Database field, type a name for the database.
4. Click Create Database.
5. Click Go Back.

• Delete a MySQL Database

1. Navigate to the Current Databases section of MySQL Databases.
2. In the Actions column of the table, click Delete next to the database you want to delete.

3. Confirm that you want to permanently remove the database.

• Create a Database User

1. Log into cPanel and locate Databases.
2. Click MySQL Databases.
3. Click Jump to MySQL Users in the top-left corner of the page.
4. Under Add New User, enter a username.

5. Enter a password in the Password field.

To create a strong password automatically, click the Generate Password button.

6. Retype the password in the Password (Again) field.
7. Click Create User.