Unix Developer

Getting Started

1. Telnet to the webserver

Either open a telnet client or in Windows click on “Start” then “Run” and type “command” in the box and click “ok”

Type “telnet (name of webserver)” and hit return

Enter your login then hit return and then enter your password then hit return (note that some clients may not show what you’re entering for password.

If you’ve logged in successfully it will give you a response like this –

“Linux 2.4.18.
Last login: Wed Feb 18 09:18:07 +0000 2004 on pts/3 from ip-195-149-34-222.nildram.co.uk.
No mail.”

If not it will prompt you for a login again

2. Connect to the database

At the prompt you will now enter your login details to the MySQL server (these details may be different to your FTP details)

If you are hosting on the mysql.nildram.co.uk server then you will need to specify the server as well as the username and password, see below examples –

Example 1)

This is how someone hosting on mysql.nildram.co.uk would connect:

:~$ mysql -hmysql.nildram.co.uk -ulogin –ppass

Example 2)

This is how someone who’s MySQL is on the same server as their webspace would connect:

:~$ mysql -ulogin –ppass

Note that the –u specifies the login/username and –p specifies the password

If connected successfully you should see something like the following…

Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 480667 to server version: 3.23.54-log

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

At this point you’ve successfully connected to the server and need to select your database, type use and then your login name eg “use login”

If successful you should get something like the following –

Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql>