ICT users can make use of a MySQL database for their study and research. This page gives some guides on accessing and using your database. It assumes you know SQL and MySQL (see Reference Manuals for more info).
ICT students already have a MySQL account and database created for them:
Note that your username/password are linked to your ICT Linux server account. You should not attempt to change your password within MySQL. You should only change your Linux account password, which will automatically also change for MySQL (and Moodle and others).
Access to the MySQL server on ICT (ict.siit.tu.ac.th) is only via localhost. In practice, that means you have two means for issuing queries on your database:
Short examples of both methods are given in the following sections.
You first need to login to ICT server using SSH. From a Linux or MacOS computer you can open a Terminal and type:
After entering your username and password you can run mysql (replace USERNAME and DATABASE with your values):
mysql -u USERNAME -p DATABASE
Now you can issue SQL queries on your database.
PhPMyAdmin is installed on ICT server. This provides a web-based interface for you to manage your database. It is available via:
To login to PhpMyAdmin, user your MySQL username/password. Further info about using PhpMyAdmin can be found through its online documentation.
Go back to the index page.