MySQL

From CSEE Documentation
Revision as of 14:02, 23 October 2013 by Gweiss (talk | contribs)
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.

CSEE computer account users are allowed 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 at my.cs.umbc.edu. 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), your UMBC username, and the password that you'll be given via email.