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:
   1. Putty
   2. 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