Create a MySQL Database
- Just Log into cPanel.
- Under Databases,just click MySQL Databases.
- In the New Database field, type a new unique name for the database.
- Just Click -> Create Database.
- Just Click ->Go Back.
The new database will appear in the Current Databases table.
Delete a MySQL Database
- Move towards the Current Databases section of MySQL Databases.
- Click Delete Database next to the database which you would like to delete.
Create or Delete a Database User
- Just Log into cPanel.
- Under Databases,Just click MySQL Databases.
- Just Click Jump to MySQL Users in the top-right corner of the page.
- Under Add New User, enter a username.
- Just Enter a secure password in the Password text field.
- For help generating a strong password, click the Generate Password button.
- Simply, retype the password in the Password (Again) field.
- Click Create User.
Delete a Database User
- Move toward the 'Current Users' under MySQL Databases section.
- X next to the user you wish to delete.
Assign Privileges to Database User
- Simply, Log into cPanel.
- Under Databases, click -> MySQL Databases.
- Under -> Add User to Database, Just select -> a user from the User drop-down menu.
- From the Database drop-down menu, select -> the database to which you would like to allow the user access.
- Just Click Add.
- Now, select the privileges you wish to grant to the user, or select ALL PRIVILEGES.
- Click Make Changes.