How to add a user to a database and add privileges?

1. Log into your cPanel account.
2. In the "Databases" section, click on "MySQL Databases" Icon.
 

3. Scroll down to the end of the page and under "Add User to Database", select a user from the dropdown list, and then choose a Database from the list.

4. Click on the "Add" button.


5. On "Manage User Privileges", mark the box "ALL PRIVILEGES" and click on "Make Changes".
  • 0 Users Found This Useful
Was this answer helpful?

Related Articles

Can I connect to SQL database using SQL Server Management Studio?

Yes, you can use Microsoft SQL Server Management Studio to remotely connect with your database on...

How do I manage MySQL Databases using PhpMyAdmin in cPanel?

Managing a MySQL database in PHPMyAdmin In this article, we'll give a brief introduction to...

How to rename a database in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "MySQL Databases"...

How to Repair database via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...

How to export database table via phpMyAdmin in cPanel?

1. Log into your cPanel account.2. In the "Databases" section, click on "phpMyAdmin" Icon. 3. In...