= 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
 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]]