PhpMyAdmin MariaDB Access Denied Error: Difference between revisions
Add phpMyAdmin / MariaDB Access Denied Error page |
m Add screenshot for User Management |
||
| Line 13: | Line 13: | ||
# Click on the username mentioned in the phpMyAdmin error message | # Click on the username mentioned in the phpMyAdmin error message | ||
# Copy/paste a strong password into the password fields | # Copy/paste a strong password into the password fields | ||
# Click on the | # Click on the 'OK' button to save the changes | ||
[[File:db-user-management.png]] | |||
{{Info|Keep in mind if you change your password or your database user, you will need to update the config files of any applicable software. | {{Info|Keep in mind if you change your password or your database user, you will need to update the config files of any applicable software. | ||
| Line 21: | Line 23: | ||
= Further Support = | = Further Support = | ||
If you’re still having trouble after double-checking you followed all the steps above, please post a topic in the [ | If you’re still having trouble after double-checking you followed all the steps above, please post a topic in the [https://helionet.org/index/forum/45-customer-service/?do=add 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. | ||
Revision as of 22:19, 10 December 2024
phpMyAdmin / MariaDB Access Denied Error
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
- 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.
Further Support
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.