Putty and winscp off campus

From SQLZOO
Jump to navigation Jump to search

Start WinScp to connect inf08104.napier.ac.uk

Get WinScp and Putty

Start WinScp

Click New

Winscp3.png

Enter details of the server

Enter the target machine

Winscp2.png

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

  • Tick Advanced Options

Tunnel.png

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

Winscp4.png

Write your SQL and Save

Winscp5.png

Try it in mysql

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

Putty2.png

When putty gets to socweb8 it immediately connects to inf08104

Putty3.png


  • Go into the mysql prompt
    mysql -u 40000036 -ptiger 40000036
  • Load in the file
    \. mksrc.sql

Putty10.png

DataWars, Data Science Practice Projects - LogoDataWars: Practice Data Science/Analysis with +100 Real Life Projects
Retrieved from "https://sqlzoo.net/w/index.php?title=Putty_and_winscp_off_campus&oldid=38708"