How to Grant a Database User Access to a Database

Sometimes you need a database user that already exists to also have access to a second database, for example if a developer needs one login across a staging and a live database. Both control panels support this, though the process differs.

In cPanel

1. Log in to cPanel and open MySQL Databases.
2. Scroll to Add User To Database.
3. Select the existing user from the User dropdown and the target database from the Database dropdown.
4. Click Add.
5. On the privileges screen, tick the specific privileges the user needs, or ALL PRIVILEGES for full access, then click Make Changes.

In DirectAdmin

1. Log in to DirectAdmin and open MySQL Management.
2. Open the database you want to grant access to.
3. Under the user access section, select the existing username from the list of available users.
4. Click Modify or Add to confirm.

Choosing Privileges

If a user only needs to read data, for example a reporting tool, grant SELECT only rather than full privileges. Most applications that write to their own database, like a CMS or e-commerce platform, need broader privileges including SELECT, INSERT, UPDATE, and DELETE at minimum.

Avoid granting one user access to every database on the account unless there's a specific reason. Keeping database access scoped to what each application actually needs limits the damage if a single application is ever compromised.