This is an old revision of the document!
CS MySQL
Computer Science hosts a MySQL server (mariadb-5.5.56-2) at the DNS address mysql.cs.virginia.edu
. Accounts for this server are created by request via cshelpdesk@virginia.edu.
Server Info
Server | mysql.cs.virginia.edu |
---|---|
TCP/IP Port | 3306 |
Currently the MySQL server is hosted on the same physical server as the web server. This means that both mysql.cs.virginia.edu
and www.cs.virginia.edu
, however we ask that you only use mysql.cs.virginia.edu
to connect so that if this ever changes in the future you won't have issues.
Accounts & Access
For new MySQL accounts, you should receive an email at the time of creation including your username and password. Your username will be the same username you use for CS systems and NetBadge. Your user will come with one database created. This database will have the same name as your username.
You will also have the ability to create additional databases with the naming format username_*
. For example, the user abc6de would be able to create the following valid databases:
abc6de abc6de_db1 abc6de_example abc6de_1