Search Our Database
How to Fix phpMyAdmin “Access Denied” Error in cPanel
Introduction
When accessing 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 arises when the MySQL password for the cPanel user is out of sync, preventing authentication. To resolve this, reset the cPanel password to force 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: Log in to WHM as the Root User
Begin by logging into WHM using the root credentials.
https://yourserverip:2087
Step 2: Access the “List Accounts” Section
- Scroll down and navigate to the List Accounts section.
- Click on List Accounts to view all existing cPanel accounts.
Step 3: Locate the cPanel Account
- Search for the cPanel account associated with the domain issue.
- Click the + icon next to the account to expand account details.
Step 4: Reset the cPanel Password
- Enter a new password (or re-enter the same password).
- Click Change Password to apply the update.
Step 5: Verify phpMyAdmin Access
- Go back to the cPanel dashboard.
- Click on phpMyAdmin under Databases.
- If the reset was successful, you should now be able to log in without errors.
Conclusion
The 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 further assistance, please contact our support team at support@ipserverone.com.