Creating a MySQL 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.

Was this answer helpful?

 Print this Article

Also Read

Grant a user's permissions to a MySQL database

Overview Once a MySQL user is created, they will need to be given permission to access any...

Removing a MySQL database

Overview Since most accounts have MySQL database creation limits, it is recommended to remove...

How To Import Large MySQL Files

1. Bigdump:http://www.ozerov.de/bigdump.phpA script called BigDump.php, a staggered SQL dump...

Creating a MySQL database

Overview SQL stands for Structured Query Language. SQL is an international standard in...

Removing a MySQL user

Overview When a MySQL user is no longer deleted, you can remove them to prevent them from...