You must connect to a Hartford cmapus UNIX workstation to access the MySQL client software. The remote access host is sparky.ewp.rpi.edu

You will need three things. Secure-Shell cleint software on your local computer. You need to know your username and password for both MySQL and your Hartford Network Account, which is different from your Troy campus account.

For more information on creating a Secure-Shell connection from a MS Windows or MacOS, read this PDF file: SShell_setup_ Instructions.pdf

For more information about getting both your MySQL and Hartford Network Account informaiton; Click Here

For more information about UNIX commands, read this tutorial.

$ ssh sparky.ewp.rpi.edu

Once connected to the host computer, and you are at a UNIX command prompt. You will next connect to another internal RPI host called, VNC1-112.

$ ssh vnc1-112

To start the ad-hoc MySQL command line tool you will need your MySQL username and password. These are normally your Hartford campus Network username and password. In the examples below you will see the word, username, replace it with your own Hartford username.

To connect to the local database with MySQL command line tool, type (with out the quote marks), ‘mysql -p -u username username’. Yes, you should type your username twice. This will place you in your own schema (database). If you forget to type your username a second time. You can use the mysql USE command, 'use username', to move into your own schema. You only have permissions with in your own schema.

$ mysql -p -u username username

After successful login you should see the MySQL prompt MYSQL>:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 60
Server version: 5.0.51 Source distribution

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql>