- Sign in to the cPanel account.
- Click on the icon ‘MYSQL databases’ in the database section
- Scroll to the bottom of your page and find ‘add a user to database’, choose a relevant user from the drop-down list and then select the required database.
- Click on the ‘Add’ button
- You will find ‘manage user privileges’, then mark the box ‘add privileges’ click ‘make changes’