How to Add and Assign User to MySQL Database

1. Login to your cPanel account.
   

2. Click on "MySQL Databases" as seen below
   

3. Type the name of your new database under “Create New Database” and press “Create Database”.
   
   You shall see the message: “Added the database yourusername_newdatabase”. Hit the “Go back” button.

4. Now, scroll down to the bottom to “MySQL Users”. Enter your preferred username and password and hit “Create User”.

You can also choose a randomly generated password by selecting “Generate Password”.

5. You shall see the message “You have successfully created a MySQL user named “youruser_newdata”.” Hit the “Go Back” button.

6. Next, we scroll down to "Add Username to Database" section and assign our newly created username to our newly created database. In this example shown below, user "youruser_newdata" will be assigned to "youruser_newdatabase". Remember to hit the "Add" button.

7. Tick on “All Privileges” and hit the “Make Changes” button.

8. You shall see that your new user is now assigned to your new database.

Updated on: 10/08/2018