Create a database and a dedicated application user Print

Quick answer

Database users need a deliberate assignment to the website's database. In cPanel, create the database and user if needed, connect them through Add User To Database, and grant the application's required privileges. Keep complete account-prefixed names and the protected application settings consistent.

Applies to

Use an authorized Interactive Online cPanel service with database capacity and the relevant tools enabled. The website installer may already have created its database. Confirm the intended application and existing objects before adding another user or database.

Create the database and dedicated user

1. Open Databases > Database Wizard for a guided new setup, or Manage My Databases to inspect/manage existing objects. Older interfaces may use MySQL in these labels.
2. Use the intended database or create one for the approved application. Record its complete prefixed name. A short suffix alone may not work in the application.
3. Create a dedicated application user with a unique password through the secure interface. Save it in a password manager and protected application configuration. Your customer-account login and hosting login are separate identities.

Assign database users to the correct database

1. In Manage My Databases, find Add User To Database. Select the full user and exact database, then choose Add.
2. Choose the privileges the application requires and save through Make Changes or the control shown by your version. An installer may require all privileges on this database; do not grant access to unrelated databases.
3. Review the saved association. If the user already exists, adding its relationship to the database does not require deleting or recreating the database.
4. Configure the application with the actual database name, user, password and provided host. If changing a user password, identify other applications using it and update their protected settings too.

Verify and troubleshoot

Check the application's normal connection and expected operation. Opening phpMyAdmin through cPanel single sign-on does not prove that the application's separate credentials are correct. Keep public errors from displaying secrets.

For MySQL Access denied, a user not assigned, a host mismatch or a privilege error, use the cPanel database Access denied troubleshooting guide. Do not respond by deleting the database or making every user an administrator. For incomplete/missing tables, use the import checks.

Support and related help

Contact support with the domain, tool/application, error, change time/time zone and last successful step. Keep passwords, SQL exports and full configuration files private.

Related help

• Use the Database Wizard and its preserved video
• Assign a user to a MySQL database
• Import the correct application database

Official references

• cPanel Manage My Databases
• cPanel Database Wizard

Content and official-source review: November 1, 2026. Available controls depend on your service, permissions and product version.