Navicat
Download & installl Navicat. When you start Navicat for the firat time you'll ned to create a New Connection:
| General |
| Connection Name |
mysql |
| Host Name |
mysql.cms.livjm.ac.uk |
| Port |
3306 |
| Username |
Your-MySQL-username |
| Password |
Your-MySQL-password |
If using Navicat from the computer labs, you do not need to use SSH, plus you can use the shortened name of mysql ( omitting the .cms.livjm.ac.uk bit of the Host Name). From home you do need to use SSH & the full hostnames are required.
| SSH |
| Host Name / IP Address |
ftp.cms.livjm.ac.uk |
| Port |
22 |
| Username |
Your-Windows-username |
| Authentication Method |
Password |
| Password |
Your-Windows-password |
If you can't or forget to use the Save Password options, you could be asked for two passwords:
| |
| SSH Password |
Your-Windows-password |
| username@mysql Password |
Your-MySQL-password |
SSH Secure Shell Client
Not only provides a terminal based interactive session, but can be used as a tunnel to gain access to other services which would otherwisw be blocked by the Firewall.
Please see the Putty section, as SSH Secure Shell Client doesn't work under Windows Vista. Putty also works under Windows XP, so XP users can use either Putty or SSH Secure Shell Client.
Having installed SSH, go to File -> Quick Connect and enter the details as shown. Substitute your username for cmsdwynn.
If this is the first time you've connected you must answer Yes when asked about the hosts public key. At the password prompt enter your LJMU Windows password. Your MySQL password is used in SQLyog, not here.
SSH & tunnels
Having succeeded with the Quick Connect you next need to Add a Profile, call it JMU or whatever you like that's memorable to you.
In SSH edit the JMU profile and in the Connection tab:
| Host Name |
ftp.cms.livjm.ac.uk |
| USER nAME |
Your-username |
| Port number |
22 |
In the Tunneling tab click on Add. Enter the details as shown. It is important to use a port number that Windows isn't using so high numbers > 32000 are recommended.
Click Ok, then OK again to save the profile. Whenever you make changes to your profile you must logout of SSH & then login again for the changes to take effect. Don't use the Quick Connect this time but your new JMU profile.
| Display Name |
mysql |
| Type |
TCP |
| Listen Port |
32638 |
| Destination Host |
mysql.cms.livjm.ac.uk |
| Destination Port |
3306 |
Putty
Download & installl Putty. When you start Putty you'll be greeted with the configuration screen.
| Host Name ( or IP address ) |
ftp.cms.livjm.ac.uk |
| Connection Type |
SSH |
| Port |
22 |
Next click on the + sign next to SSH. Click Tunnels.
| Source port |
32638 |
| Destination |
mysql.cms.livjm.ac.uk:3306 |
| Local / Auto |
Selected |
Click Add. Now select Session again on the left. In the Saved Sessions give the session a name like mysql, and click Save. The next time you use Putty, you'll be able to Load the sessioin settings in again, without having to re-type anything. Finally click Open and login using your LJMU Windows usernamer / password. Your MySQL password is used in SQLyog, not here.
MySQL tunnel
Although the port that MySQL uses is not enabled through the JMU Firewall, you can now use the tunnel you created. Basically your new JMU profile does the following:
| Port 32638 on your home PC |
<------------> |
The MySQL service port 3306 on host mysql.cms.livjm.ac.uk |
DON'T touch the Tunnel tab in SQLyog - you don't need to touch this at all.
Also, to use the tunnel you must be logged in via SSH using your JMU profile, or by using Putty, and remain logged in as long as you want to use it.
| SQLyog Summary |
| MySQL Host Address |
localhost |
| Username |
Your-MySQL-username |
| Password |
Your-MySQL-password |
| Port |
32638 |
| Database |
Your-MySQL-username |
Using NX No Machine to connect to linux
Download and install the NX no machine client (found in the Downloads section) accept all of the default options untill the program is installed.
Double click the icon created on your desktop and you will be presented with the NX client login interface
You can enter your username and password at this time, in the Session box type in a discriptive name , like holly or jmulinux etc you will then be asked what you wish to do. Click Create.
Next click the Configure button
In the General tab set the Server Host to : ftp.cms.livjm.ac.uk Port 22 be sure to set desktop to UNIX KDE, and alter the connection speed to the one appropriate to your home connection, leave all other options in the tab at their defaults.
That is all you need to do. Click OK then click Yes to save configuration and click Connect. Connection takes on average 8-12 seconds.
You cannot access local devices on your PC such as floppy disk or CDROM using NX No Machine. You can however use Copy from a MS-Windows application like Internet Explorer and Paste into a text editor on linux. Very handy for code snippets.
Last modified: 04-Dec-08
