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
sureshpeters
how to give admin privillage by this method??
Vivek Parmar
Read the article again. you will see that in step 6 if you click on “ALL Privileges” option you will grant admin privilege to any user.
sureshpeters
i tried this way 🙁 but not possible to login.. actually..if my admin account is hacked means..how you access the wordpress??
Vivek Parmar
i don’t found any problem like this. follow the step-by-step guide again and carefully. if your wordpress is hacked then you have to use your cpanel to get access to your wp-admin