- Creating a database
- Creating a database user
- Giving your database user access to work with your database
Creating a database
- Log into cPanel.
- Under Databases, click MySQL Databases.
- In the New Database field, enter a name for the database.
- Click Create Database.
That's it.
Creating a database user
- Log into cPanel.
- Under Databases, click MySQL Databases.
- Click Jump to MySQL Users in the top-right corner of the page.
- Under Add New User, enter a username.
- Enter a password in the Password field.
- For help generating a strong password, click the Generate Password button.
- Retype the password in the Password (Again) field.
- Click Create User.
Giving your database user access to work with your database
- 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.