Adding a MySQL user to a database

How do I Add a User to a MySQL Database?

You can easily add a user to specific MySQL databases in cPanel by doing the following instructions below.

 

  1.  Go to Home > Databases > MySQL Databases

 

Showing the MySQL Databases icon in cPanel

 

  1. Scroll to the Add User To Database section
  2. Pick the desired user and database from the menus
  3. Click the Add button

Showing how to add a user to a database in cPanel

 

  1. Set the permissions you wish to grant the user
  2. Click the Make Changes button

 

Showing MySQL Manage User Privileges form

 

  1. Click the Go Back button to return to the MySQL Databases dashboard

 

Showing the successful addition of a user to a database in cPanel

 

  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Application Cannot Connect to Database

What causes an application cannot connect to database error? There are several things that...

Creating a MySQL Database

How do I Setup a MySQL Database in cPanel? Setting up a database for your website can be done...

Creating a MySQL User

How Do I Create A MySQL User In cPanel? To create a MySQL user follow the guide below.  This...

Definition of Databases Icons

The Database section in cPanel allows you to administer every aspect of your MySQL database....

How to Increase the Timeout in PHPMyAdmin

If you have VPS and happen to be running phpMyAdmin then you may have ran into the following: No...