Putty and winscp off campus

Start WinScp to connect inf08104.napier.ac.uk

Get WinScp and Putty

• https://winscp.net/eng/index.php
• http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html

Start WinScp

Click New

Enter details of the server

Enter the target machine

You are off campus so you must tunnel in via socweb8.napier.ac.uk

• Tick Advanced Options

Create a new file (called mksrs.sql or similar)

Write your SQL and Save

Try it in mysql

• Start putty, connect to inf08104.napier.ac.uk - but go via socweb8.napier.ac.uk

When putty gets to socweb8 it immediately connects to inf08104

• Go into the mysql prompt

  mysql -u 40000036 -ptiger 40000036

• Load in the file

  \. mksrc.sql