[How-To Guide] Create New User In MySQL Database

MySQL, most popular database which allows you to run content-driven websites. MySQL database managed by using third-party programs such as PHPMyAdmin because it offers you a quick and easy database administration process. Already I had provided you lots of guides on MYSQL Database from installation to some advanced level. Here is a quick round-up of all the posts.

Install MySQL Offline On Your PC

Configure MySQL Offline On Your PC

Checking MySQL Installation Works On PC or Not?

Repair And Optimize WordPress Database Using WordPress Hidden Feature

Optimize WordPress Database Using PHPMyAdmin

Repair WordPress Database Using PHPMyAdmin

Top WordPress Plugin To Optimize WordPress Database

All these posts help you out in getting friendlier with MYSQL database. This post focus on creating a new user in MySQL. Follow the step-by-step guide to create user.

Step1: Open your cPanel, under it click on MySQL Database option as shown below:

Step2: After clicking on MySQL database, it will open a new page. Now scroll down and you see the “MySQL Users” as shown below in screen-shot:

Step3: After clicking on “Create User” button a new user-created and it looks like this:

Step4: The new database user will be “cpanelusernmae_admin” (admin is the username of that database you’ve created).

Step5: Now click on “Add” button to “Add User to Database” as shown below:

Step6: Now select the privileges you assign to this user and after assigning privileges click on “Make Changes” button.

Step7: Congratulations, you have successfully added new user to database.

This tutorial guides you in creating more users to your database.

If you face any problems then let us know in the comments section. To get all the latest information you can follow us on Twitter