MySQL

From CSEE Documentation
Revision as of 11:07, 8 May 2009 by Willm1 (talk | contribs) (New page: CSEE allows users to request one or more MySQL databases. The accounts given through this interface can do anything standard MySQL can do, with the exception that you are limited to one d...)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

CSEE allows users to request one or more MySQL databases. The accounts given through this interface can do anything standard MySQL can do, with the exception that you are limited to one database. You may request any alphanumeric string as the name of your database, but if someone else has already taken that name they have precedence. The string you give is prepended with "user_", so if you request the database "foo" and nobody has taken it, you will be granted a database by the name "user_foo". We suggest that you pick a name that describes the purpose of your database rather than who owns it, although there is no prohibition on picking, say, your own username as a database name. However, if you're doing a group project, it may be a better idea to pick something related to the project, so if you graduate and someone else takes over the project, the name of the database will be sensible.

To get a CSEE database account, submit a ticket through the standard interface. Mention that you want a database and what name you want for it.

Once you've been granted a CSEE database account, you can connect to it at db1.cs.umbc.edu on port 3306 (the standard port for MySQL)