cPanel is fantastically easy to use. Most web masters will find they need few other tools to enable them to manage their sites, files, databases and emails. As easy as cPanel is to operate, it can take a few weeks to get to grips with all its features.
In this guide you will learn how to create a new database user and how to add that user to an existing database.
If you want to create a new database and a new user together then this guide is not the guide you want to read.
How to create a new database user
- log into cPanel
- click the MySQL Databases icon
- scroll to MySQL Users
- Enter a new username and password
- click Create User
A confirmation screen will show once the new user is created. Copy the user’s details so you don’t forget them then click Go back at the bottom of the page.
How to add a database user to a database
- log into cPanel
- click the MySQL Databases icon
- scroll to Add User to Database
- select the user and the database in the dropdown select boxes
- click Add
- on the new screen, select all database privileges
- click Make Changes