MySQL: Configure GUIs

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 get a reliable MySQL database ready in just a few minutes. Spend less time on setup and maintenance, and focus on developing your applications. Try MySQL cloud hosting on Stackhero today.

Connecting Tableau to MySQL

Tableau is a powerful visual analytics platform that allows you to create dynamic dashboards by connecting directly to your MySQL database.

To connect Tableau to MySQL:

1. Open Tableau and start a new connection.
2. Select MySQL as your data source.
3. Enter the necessary credentials: server host address, username, password, and port number.
4. Confirm the connection. Tableau uses SSL by default to ensure secure communication.

If you encounter an error like "SSL connection error: unknown error number", consider enabling the "Support old TLS version" option in the MySQL service configuration on the Stackhero dashboard to resolve the issue.

Connecting HeidiSQL to MySQL

HeidiSQL is a lightweight, user-friendly database management tool. Here is how you can configure it to connect to MySQL:

1. Launch HeidiSQL and create a new session.
2. Fill in the required fields: Hostname, User, Password, and Port.
3. Ensure the Library setting is set to libmariadb.dll.

HeidiSQL Configuration Example

To enable SSL encryption:

1. Go to the SSL tab.
2. Enable the Use SSL option.

Stackhero employs TLS certificates issued by trusted Certificate Authorities (CAs), so no additional certificates need to be imported.

Enable SSL/TLS Encryption in HeidiSQL

Troubleshooting authentication issues

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

Connecting Sequel Pro to MySQL

Sequel Pro, while previously popular, has not been updated since 2016. It relies on outdated TLS versions that are incompatible with recent MySQL and MariaDB releases.

A community-driven fork, Sequel Ace, has taken its place. Actively maintained and open-source, Sequel Ace provides similar functionality. Learn more on GitHub or download it from the Apple App Store.

Connecting Sequel Ace to MySQL

Sequel Ace offers a straightforward interface for connecting to MySQL:

1. Open Sequel Ace and create a new connection.
2. Fill in the details: Host, Username, Password, and Port.
3. Enable the Require SSL option to secure the connection.

Sequel Ace Configuration Example