= UoL LAMP HowTo Connect to MySQL Remotely

Tags: [[UoL LAMP Server]] [[HowTo]] [[MySQL]]

== Procedure

1. First create a ssh tunnel using one of these methods:
 a. Putty - See [[https://www.electrictoolbox.com/putty-create-ssh-port-tunnel/|Create SSH tunnel using putty]]
 b. Run the command `ssh {username}@login{xx}.lamp.le.ac.uk -L 4444:127.0.0.1:3306 -N`
2. Connect using MySQL Workbench or by running the command `mysql -u {username} -p --port=4444 -h 127.0.0.1`
3. The port `4444` used here can be change to whatever port number is required.

[[BackLinks]]