Putty and winscp off campus

From SQLZoo

Start WinScp to connect inf08104.napier.ac.uk

Get WinScp and Putty

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

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects
  • Your server today is: digitalocean-sqlzoo