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