Creating a database
- Log into cPanel.
- Under the “Databases”, click “MySQL databases”.
- In the “Create database” field, type the name of your new database.
- Click “Create database”.
Creating a user
- Log into cPanel
- Under the “Databases”, click “MySQL databases”.
- Click “Jump to MySQL users”.
- Find a set of fields called “Add a New User”.
- Enter a username in the corresponding field and password into both “Password” and “Password (confirm)”.
- Click “Create User”.
Giving access to the 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 to 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”.