MySQL server

CS hosts a MySQL server at the DNS address mysql.cs.virginia.edu. Accounts for this server are created by request via cshelpdesk@virginia.edu.

Server Info

CS Department Server

Server mysql.cs.virginia.edu
TCP/IP Port 3306
phpMyAdmin https://www.cs.virginia.edu/csdb

CS 4750

Server cs4750.cs.virginia.edu
TCP/IP Port 3306
CS4750 phpMyAdmin https://cs4750.cs.virginia.edu/phpMyAdmin

CS 6750

Server cs6750.cs.virginia.edu
TCP/IP Port 3306
CS6750 phpMyAdmin https://cs6750.cs.virginia.edu/phpMyAdmin

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 point to the CS MySQL server, 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

phpMyAdmin

There is an installation of phpMyAdmin hosted on our web server at the following address: https://www.cs.virginia.edu/csdb/

Linux

All of our Linux servers and desktops should have the mysql command available.

PHP

Our module for PHP was built with database support and drivers for MySQL.

  • mysql_server.txt
  • Last modified: 2020/08/27 15:49
  • by pgh5a