Connecting MySQL via a Jump Server When Direct External Access Is Blocked

Problem

A teammate asked to open MySQL access, but despite having the username, password, and SSH details shared in the work group, the connection still failed with error 1045, indicating insufficient permissions for remote access.

Configure a Regular Local Connection

First, set up the usual MySQL connection parameters that are commonly used:

Host: 127.0.0.1 (local address)

Port: 3306 (adjust if your MySQL instance uses a different port)

Username: the normal database user name

Password: the corresponding password for that user

Configure the Jump Server (Bastion Host)

Next, set up an SSH tunnel through a jump server to reach the MySQL instance:

Enable the SSH channel option.

Host: enter the external IP address or domain name of the jump server.

Port: keep 22 (default SSH port).

Username: the remote user that has SSH access to the jump server.

Password: the password associated with that SSH user.

Test the Connection

After completing both configurations, click the test connection button. A successful connection will display a screenshot confirming that the MySQL link is established.

The guide ends with a note that the configuration steps for using a jump server to connect to a MySQL database are now complete.