MySQL: Troubleshooting authentication issues

This documentation is part of the Configure GUIs guide. You can view the complete guide here: How to connect graphical interfaces to MySQL.

👋 Welcome to the Stackhero documentation!

Stackhero offers a fully managed MySQL cloud service that streamlines deployment and management for your production workloads:

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

With Stackhero, you have a reliable MySQL database ready within minutes. Reduce the time spent on installation and maintenance, and focus on developing 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