FAQs - 6 - MySQL

 

6.1 - How to I get a MySQL database account?
6.2 - How do I try out my account?
6.3 - What can I use this for?
6.4 - From where can I connect to MySQL.
6.5 - Which is better?
6.7 - Any graphical DB admin tools anywhere?


6.1 - How to I get a MySQL database account?

Apply using this form.

6.2 - How do I try out my account?

http://mysql.netsoc.tcd.ie/ is the web based interface to your database. Use your mysql username and password to log in.

6.3 - What can I use this for?

Dynamic websites, college projects, whatever.

See the MySQL guide.

6.4 - From where can I connect to MySQL.

Databases on matrix only accept connections from within the tcd domain. If the script or program is running on matrix, it can connect without authentication, otherwise your password is needed to connect.

This does NOT mean that you can't show everyone your cool data, it only means that the php pages you create to do database queries can only connect to your database if it's on matrix. To put it another way, any web browser can view your database-enabled website, for example.

6.5 - Which is better?

oh god, flame me now

6.7 - Any graphical DB admin tools anywhere?

Yep