How to create MySQL database user

Portal Home > Knowledgebase > Database Management > How to create MySQL database user

Overview
You need to create a MySQL user before that user is able to use the database. This does not automatically allow the user to use a database - you need to grant that user permission to the specific database first. Refer to Grant a user's permissions to a MySQL database for more information.

Steps

1 To access the MySQL Account Maintenance Menu, click on the icon above the words MySQL Databases on the main screen of your cPanel interface.

2 Enter the name of the new user in the blank field next to UserName:

3 Enter the password for the new user in the blank field next to Password:

4 Click on Add User to create the new user.

Add to Favourites Print this Article

Also Read

How to create MySQL database (Views: 1159)

Grant a user's permissions to a MySQL database (Views: 1188)

How to remove MySQL database user (Views: 855)

How to delete MySQL database (Views: 1297)

How to add table to database (Views: 1633)