Create a MySQL database
- Log into cPanel.
- Under Databases, click MySQL Databases.
- In the New Database field, type a name for the database.
- Click Create Database.
- Click Go Back.
- The new database will appear in the Current Databases table.
Delete a MySQL database
- Navigate to the Current Databases section of MySQL Databases.
- In the Actions column of the table, click Delete Database next to the database you wish to delete.
If you would like to remove a user that has been assigned to a database, click the X next to the user on this table. Please see the instructions below on how to assign a database user.
After creating the database, you will need to create a user and assign privileges. Please note that MySQL user accounts must be created separately from mail and web administrator accounts.
Create a database user
1. Log into cPanel.
2. Under Databases, click MySQL Databases.
3. Click Jump to MySQL Users in the top-right corner of the page.
4. Under Add New User, enter a username.
5. Enter a password in the Password field.
6. Retype the password in the Password (Again) field.
7. Click Create User.
Delete a database user
- Navigate to the Current Users section of MySQL Databases.
- In the Delete column, click the X next to the user you wish to delete.
Privileges determine how a user is able to interact with the database. For example, privileges will dictate whether or not the user can add and delete information.
Assign privileges to database user
- Log into cPanel.
- Under Databases, click MySQL Databases.
- Under Add User to Database, select a user from the User drop-down menu.
- From the Database drop-down menu, select the database to which you wish to allow the user access.
- Click Add.
- From the MySQL Account Maintenance screen, select the privileges you wish to grant the user, or select ALL PRIVILEGES.
- Click Make Changes.
Unassign a user from a database
- Navigate to the Current Databases section of MySQL Databases.
- Locate the database you wish to modify.
- In the Users column for that database, click the X next to the user you wish to delete.