Search Our Database

Error: “Access Denied for User” in phpMyAdmin (cPanel)

Last updated on |
by

Introduction

When attempting to access phpMyAdmin through cPanel, you may encounter the following error:

Error: mysqli_sql_exception: Access denied for user ‘cpses-username’@’localhost’ (using password: YES) .

This issue occurs when the MySQL password for the cPanel user is out of sync, preventing authentication. To resolve this, you need to reset the cPanel password, which forces MySQL to synchronize the credentials.

Prerequisites

  • Access to WHM (Web Host Manager) as a root user or a reseller with the necessary privileges.
  • Basic Knowledge of WHM
  • Access to the cPanel Account

Step-by-Step Troubleshooting

Step 1: Reset the cPanel Password

  1. Log in to WHM.
  2. Navigate to List account
  3. Enter a new password (or re-enter the same password).
  4. Click Change Password to apply the update.

Step 2: Verify phpMyAdmin Access

  1. Go back to the cPanel dashboard.
  2. Click on phpMyAdmin under Databases.
  3. If the reset was successful, you should now be able to log in without errors.

Conclusion

This issue occurs due to MySQL authentication caching, which prevents immediate recognition of the cPanel user’s password. Resetting the password forces MySQL to sync with cPanel authentication, resolving the login issue.

If you need more help, feel free to contact our support team at support@ipserverone.com.

Related Article