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 offers a ready-to-use MySQL cloud solution that provides a host of benefits, including:

• Unlimited connections and transfers.
• phpMyAdmin web UI included.
• Effortless updates with just a click.
• Optimal performance and robust security powered by a private and dedicated VM.

Save time and simplify your life: it only takes 5 minutes to try Stackhero's MySQL cloud hosting solution!

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