MariaDB: Configure GUIs

How to connect graphical interfaces to MariaDB

👋 Welcome to Stackhero documentation

Stackhero provides a ready-to-use MariaDB cloud service designed for production workloads. You get:

• Unlimited connections and data transfers.
• Built-in phpMyAdmin web interface for database management.
• One-click updates for easy maintenance.
• High performance and strong security on private, dedicated infrastructure.

Launch a fully managed MariaDB instance in minutes. Stackhero handles setup, updates, and security so you can focus on your application. Learn more about MariaDB cloud hosting.

Connecting Tableau to MariaDB

Tableau offers an intuitive way to create insightful dashboards by linking it to your MariaDB database.

To get started with Tableau:

1. Launch Tableau and initiate a new connection.
2. Choose MariaDB as your database type.
3. Provide the necessary details:
   • Host server
   • Username
   • Password
   • Port
4. Test the connection to ensure it is working.

By default, the connection is made using SSL. If you run into the SSL connection error: unknown error number, navigate to the MariaDB service configuration in the Stackhero dashboard and enable the "Support old TLS version" option.

Connecting HeidiSQL to MariaDB

Follow these steps to connect HeidiSQL to MariaDB:

1. Open HeidiSQL and start a new session.
2. Enter the following information:
   • Hostname
   • User
   • Password
   • Port
3. Ensure the default library is set to libmariadb.dll.

HeidiSQL configuration prompt

Enabling SSL/TLS encryption in HeidiSQL

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

note There is no need to manually add certificates for the SSL connection.

SSL/TLS encryption setup in HeidiSQL

Connecting Sequel Pro to MariaDB

Sequel Pro, last updated in 2016, is no longer maintained. Its outdated TLS support makes it incompatible with modern MariaDB and MySQL versions.

Alternative: Sequel Ace

To address the limitations of Sequel Pro, the community developed Sequel Ace, which is actively maintained. You can download it from the Apple App Store or its official website.

Connecting Sequel Ace to MariaDB

To connect MariaDB using Sequel Ace:

1. Launch Sequel Ace and create a new connection.
2. Input the following details:
   • Host
   • Username
   • Password
   • Port
3. Select the Require SSL checkbox to enable secure connections.

Example Sequel Ace configuration