Skip to main content

How to Connect to a Hostek MySQL or MariaDB Database With MySQL Workbench

Connect to your MySQL or MariaDB database using the MySQL Workbench desktop application. This guide is intended for customers who need to manage their database locally using a dedicated GUI tool.

Connect to your MySQL or MariaDB database using the MySQL Workbench desktop application. This guide is intended for customers who need to manage their database locally using a dedicated GUI tool.

Before you begin

You will need:

  • A Hostek account with access to a MySQL or MariaDB database.

  • The MySQL Workbench application installed on your local computer.

  • Your database credentials (hostname, port, username, and password).

Connect to the database

  1. Open MySQL Workbench on your local computer.

  2. Click the + icon next to MySQL Connections to create a new connection.

  3. Enter a connection name (e.g., Hostek_Production).

  4. In the Hostname field, enter the IP address or hostname provided by Hostek for your database.

  5. Ensure the Port is set to 3306 (unless your specific database uses a non-standard port).

  6. Enter your Username and click Store in Vault to enter your password.

  7. Click Test Connection.

Note: If the connection fails, ensure that your local IP address is authorized to connect to the Hostek server.

Confirm the result

  • MySQL Workbench will display a success message indicating the connection was established.

  • The database schema and tables will appear in the left-hand sidebar of the MySQL Workbench interface.

If you receive an "Access Denied" error

If you receive an "Access Denied" error, verify the following:

  • Credentials: Ensure the username and password are correct.

  • Host Permissions: Confirm that your specific database user is permitted to connect from your current IP address.

  • Port Access: Ensure your local firewall or network is not blocking outgoing traffic on port 3306.

Limitations

This procedure requires that your local machine has an active internet connection and that the database's firewall rules allow your specific IP address to connect. If you are using a VPN, the connection may be blocked by the VPN's security settings.

Did this answer your question?