Create MySQL User Account in cPanel
MySQL Database is an open source Relational Database Management System software which helps to store, retrieve, organize and update the contents in Database.
This article will show you How to create a MySQL User account in cPanel. MySQL database is very useful to run many web-based applications. It works as a backend and mostly used in CMS (Content Management System) and etc.
The MySQL root user has full access to all of the databases. However, other database users have some restrictions to access the database. You can create MySQL user with the custom privileges. The user can be granted various kinds of privileges in accessing the database.
You can add a user to your MySQL Database or create a user, by following the below simple steps
Step 1 Login to cPanel with appropriate username and password. After logged in, you can view the database option in cPanel Dashboard.
Step 2 Click MySQL Database Wizard under Database section.
Step 3Type a name for your database and click the Next Step button.
Step 4 Follow these steps
Type a UserName.
Type the Password twice.
Click the Create User Button and move onto the next step.
Step 5 Successfully Created a MySQL user named as “demoserv_admin” and Set privileges to the user.
Once the Successful message is shown in the cPanel, you can view the list of database user in the MySQL Database. Under the current user, you can reset the password also.
The above steps have illustrated the process to create the database and MySQL user to access the database.