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

phpMyAdmin

Overview phpMyAdmin allows you to administrate all of your mySQL databases. To learn more...

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 user

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

How To Import Large MySQL Files

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

Removing a MySQL database

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