Howto SSH¶

Create Tunnel¶

Create a tunnel to port 3306 on the remote server. This is the standard port for MySQL. Example:

ssh -N -f -L 13306:localhost:3306 \
    sshuser@remote-server.com

Options:

Provide MySQL Access Rights¶

Make sure the MySQL user and the database are opened to TCP access:

UPDATE USER SET host='%' WHERE user='DBUSER';
UPDATE DB SET host='%' WHERE user='DBUSER';

Connect to Remote MySQL Service¶

Now you can connect to the MySQL service running on the server:

localmachine>$  mysql -h 127.0.0.1 -P 13306 -u DBUSER -pDBPASSWORD

# in file: /etc/mysql/my.cnf

## disable remote access:
#bind-address           = 127.0.0.1

# enable remote access:
bind-address            = 0.0.0.0

# Restart MySQL after changing this section - a reload is not enough:
$ service mysql restart