How to assign a user to a MySQL database in cPanel Print

  • 4

Quick answer

Assign an existing database user to the exact database and grant the application's required privileges. A user can have different permissions on different databases.

Applies to

For Interactive Online cPanel customers with permission to manage the selected service. The tool must be enabled on your plan. Open the correct service from the Client Area before changing anything. The preserved video shows an older interface. In cPanel 120 and later, Manage My Databases replaces the older MySQL Databases label. Database and user names may include an account prefix.

Steps

  1. Open Manage My Databases. Under Add User to Database, select the full user and database names.
  2. Choose Add, select the required privileges and save with Make Changes. Use All Privileges only when appropriate for the application.
  3. Record the resulting association and keep privileges limited to the intended application scope.

Check the result

Confirm the user is listed against the intended database and test the application's normal database operation.

Troubleshooting and support

An Access denied error can also involve the host, saved password or another prefixed name. Do not grant access to every database as a troubleshooting shortcut.

If the problem continues, contact support from the account that owns the service. Include the domain, exact error, time and time zone, tool name, and a redacted screenshot. Keep passwords, private keys, cookies and private message content out of the ticket.

Video tutorial

The original video is preserved. Its interface or product version may differ from the written guidance above.

Video not playing? Watch this tutorial on YouTube.

Related help

Official references

Written content reviewed November 1, 2026. Menu availability depends on the product version, permissions and service.


Was this answer helpful?

« Back