Version 2 (modified by 9 years ago) ( diff ) | ,
---|
UoL LAMP HowTo Connect to MySQL Remotely
Tags: UoL LAMP Server HowTo MySQL
Procedure
- First create a ssh tunnel using one of these methods:
- Putty
- Run the command
ssh {username}@login{xx}.lamp.le.ac.uk -L 4444:127.0.0.1:3306 -N
- Connect using MySQL Workbench or by running the command
mysql -u {username} -p --port=4444 -h 127.0.0.1
- The port
4444
used here can be change to whatever port number is required.
Note:
See TracWiki
for help on using the wiki.