PhpMyAdmin MariaDB Access Denied Error: Difference between revisions
Add phpMyAdmin / MariaDB Access Denied Error page |
m Update to use H2 headers for better readability |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
= phpMyAdmin / MariaDB Access Denied Error = | == phpMyAdmin / MariaDB Access Denied Error == | ||
When trying to login to phpMyAdmin to access MariaDB, if you get an error message that says: | When trying to login to phpMyAdmin to access MariaDB, if you get an error message that says: | ||
| 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 | # 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 | |||
[[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 19: | Line 22: | ||
For instance, if you're using WordPress (which [[:WordPress|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.}} | For instance, if you're using WordPress (which [[:WordPress|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 = | == 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. | ||
Latest revision as of 17:21, 17 January 2025
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
- 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.
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.