The MySQL server is installed on a dedicated machine called database.cs.ait.ac.th.

As a user of CSIM system, you have an account open on the MySQL server. Your
account has the same user name and password as your normal Unix or samba account.
When you change your Unix password, with the web
page for account management, it will also change your MySQL password.

Note: if your account on CSIM system was created before the MySQL server
was installed (before November 15th, 2001), you have to first go
to the web page for account
management and change your password once to open your MySQL account.

You have access to a database that is created for your own usage, it has the
same name as your user name on Unix or samba. Among the many databases available
on the server, you can only use the one that has your user name. For security
reason, you can use this server only from CSIM network.

As a summary:

Server name:

database.cs.ait.ac.th

Port:

3306 (default)

User name:

your user name

Password:

your password

Database:

your user name

CSIM server banyan.cs.ait.ac.th and our web server have the libraries
installed to access MySQL server, either directly with the mysql tool
or with Perl scripts. Below is an example of a MySQL session on banyan:

MySQL-Front is one of the many
free clients for Windows that allow you to create and manage your database with
a graphical interface.

This software does not have a fancy installation procedure, just download
it and unzip it somewhere (in C:\Program Files\MySQl-Front
for example). You will also have to make an entry in C:\Windows\Start Menu.

When you access MySQL-Front for the first time you have to create a new connection.
Do not save the connection with your password, else
any user will be able to connect to your database.

I noticed
the following while using MySQL-Front:

When canceling a cell modification with ctrl-z, it will repeat the last
modification you just made;

When importing from ODBC,you cannot select the target database in the dialogue
window, instead you must open the database before you choose Import ODBC;

I had a strange condition when trying to drop a database, be sure you carefully
select the database and/or table you want to drop.

What I especially like with MySQL-Front is the SQL requests that are displayed
at the bottom of the screen with ever operation made on the database.

The server is a stand-alone machine, where you cannot store your files; to
import data, you can use the command LOAD with the LOCAL:

LOAD DATA LOCAL INFILE 'file_name.txt' INTO
TABLE tbl_name

To export files, there is not such an option. Instead you can export data from
MySQL-Front if you are using Windows environment, or you can do it via a short
program that will read the table reccord by reccord, and store the in a file.