MySQL: Troubleshooting authentication issues

This documentation is part of the Configure GUIs guide. View the full guide here: How to connect graphical interfaces to MySQL.

👋 Welcome to the Stackhero documentation!

Stackhero provides a fully managed MySQL cloud service that simplifies deployment and management for production workloads:

• Unlimited connections and data transfers.
• Integrated phpMyAdmin web interface for easy database management.
• Hassle-free updates with one-click upgrades.
• Consistent performance and strong security on a private, dedicated infrastructure.

With Stackhero, you can have a reliable MySQL database ready in just a few minutes. Spend less time on setup and maintenance, and more time building your applications. Try MySQL cloud hosting on Stackhero today.

When using libmariadb.dll, HeidiSQL supports advanced TLS ciphers but may face compatibility issues with MySQL's default "Caching SHA2 password" authentication plugin. If you receive an "Access denied" error, try the following solutions:

• For the root user, change the authentication plugin to MySQL native password using the Stackhero dashboard.
• For other users, modify the authentication plugin through phpMyAdmin.

Set MySQL Authentication Plugin