Difference between revisions of "MySQL"

From CSEE Documentation
Line 1: Line 1:
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.
+
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 [https://my.cs.umbc.edu my.cs.umbc.edu].  Mention that you want a database and what name you want for it.
 
To get a CSEE database account, submit a ticket through the standard interface at [https://my.cs.umbc.edu 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.
 
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.

Revision as of 14:02, 23 October 2013

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.