Creating a database user in cPanel

Identify the database the application should use and the permissions required by its installer or documentation. Use a long unique generated password and store it securely. Do not put database credentials in a public text file or send them in an ordinary support message.

1. Open Manage My Databases, or MySQL Databases on an older cPanel layout. Find the section for creating a new database user.
2. Enter the permitted username and a strong password. Create the user and record its full displayed name, including any hosting-account prefix.
3. Use Add User to Database to select this user and the intended database. Grant the required privileges and save the assignment.
4. Update the application’s database configuration with the new credential. If replacing an existing user, retain the old one until the new connection has been tested.
5. When the transition is complete, remove unnecessary old privileges or credentials through cPanel.

Perform a normal application read and a controlled write, such as saving a test setting. A user appearing in cPanel does not prove that it has been assigned to the correct database.

If authentication fails, check the full username and password first. If login succeeds but queries fail, review privileges and database selection. Keep database creation and user management in cPanel rather than phpMyAdmin so the panel retains correct ownership mapping.

• Creating a MySQL or MariaDB database in cPanel
• Assigning a database user and choosing its privileges in cPanel
• Renaming a cPanel database without losing the application connection
• Assigning a database user only the privileges an application needs
• Deleting an unused database from cPanel

• cPanel documentation