Create a MySQL user account in cPanel
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 2: Click MySQL Database Wizard under Database section
Step 3: Type a name for your database and click the Next Step button
Step 4: To create a user, type the username, password and then click “Create User”
Step 5: Created a user and set the privileges to the user
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.
Click MySQL Database wizard
Step 3Type a name for your database and click the Next Step button.
Enter Database name and go to next step
Step 4 Follow these steps
-
Type a UserName.
-
Type the Password twice.
-
Click the Create User Button and move onto the next step.
Enter user name and password
Step 5 Successfully Created a MySQL user named as “demoserv_admin” and Set privileges to the user.
successfully MySQL Database created
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.