Adding user to a database in cPanel

Adding user to a database in cPanel

Written on December 25, 2020 by Doteasy Admin

Managing MySQL Databases and Users in cPanel

Adding user to a database in cPanel

To add a MySQL user to a database:

Click MySQL Databases under Databases in cPanel.

Doteasy cPanel MySQL database

Under Add User to Database, select the user that you want to add from the User drop-down menu.

Doteasy cPanel adding user to database

In the Database drop-down menu, select the database.

Doteasy cPanel adding user to database

Click Add.
Select the privileges you want to grant the user, or click ALL PRIVILEGES to grant the user all permissions to the database.

Doteasy cPanel user to database all privileges

When ready, click Make Changes.

Doteasy cPanel MySQL making changes to privileges

That’s it! You can now see the user assigned to the database in the Current Databases table.

Doteasy cPanel current database

View more posts by Doteasy Admin

You may also like

December 25, 2022

Changing a database user's password

To change a MySQL user's password, access ''MySQL Databases'' in cPanel. Locate the user, click ''Change Password'', enter new password in the boxes, and then click ''Change Password''. The new password takes immediate effect.

Managing MySQL Databases and Users in cPanel

December 15, 2022

Creating a database in cPanel

To create a MySQL database, go to cPanel, click on MySQL Databases, enter a database name, then click Create Database. Your new database is now ready for use. Check the Current Databases table for confirmation. Next, add a MySQL user for database management.

Managing MySQL Databases and Users in cPanel

May 15, 2021

Modifying a database user's privileges

To modify a database user's privileges, go to MySQL Databases in cPanel. Locate the user under Current Databases, click on the username to access Manage User Privileges. Select or unselect privileges, then click Make Changes.

Managing MySQL Databases and Users in cPanel