phpMyAdmin / MariaDB Access Denied Error
Last updated
Last updated
When trying to login to phpMyAdmin to access MariaDB, if you get an error message that says:
Access denied for user 'yourusername_admin'@'localhost' (using password: YES)
Please follow the steps below to resolve the issue:
Login at heliohost.org/login
Continue to Plesk
Click on Databases
Click on User Management (see the screenshot below)
Click on the username mentioned in the phpMyAdmin error message
Copy/paste a strong password into the password fields
Double-check the permissions assigned to your database user by clicking on the Show privileges link and adjust them if needed
Click on the OK button to save the changes
Keep in mind if you change your password or your database user, you will need to update the config files of any applicable software.
For instance, if you're using WordPress (which we don't recommend), you'll need to make sure that the database password in the wp-config.php file matches the password you enter into Plesk.
If you’re still having trouble after double-checking you followed all the steps above, please post a topic in the Customer Support forum. Be sure to include your hosting account username, domain name, database name, database user name, details of the problem, troubleshooting steps you have tried, and any error message(s) received.