Using MYSQL on the CISWEB
server:
Logging
into putty.exe to use mysql;
·
Click
on putty.exe
·
Type
cisweb.bristol.mass.edu in the Host
Name (or IP address) box. You can save
these settings by typing cisweb in
the Saved Sessions box and then click the Save
button. Now click Open to start the session.
·
At
the login as: prompt type your
username, web15(or whatever
your number is)
·
Then
you will be prompted for your password, which is web3333! (Or whatever your number is …don’t forget the
exclamation point!)
·
At
the $ prompt type the following to use mysql :
$mysql –u
web15 –p
(then hit the enter key)
Enter
password: web3333!
You
should get the mysql>
prompt. Then you have to type the
command to use your own database as follows:
mysql>use pebo1(whatever your database
is named). Keep in mind that you will
only have rights to use your own database.