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. We chose to migrate to MariaDB over Oracle MySQL for a number of reasons, most notably because new versions of MySQL dropped support certain legacy features that would have forced us to drop and/or recreate almost half of our user accounts. MariaDB comes with a guarantee that it will stay open source whereas the future of MySQL is left up Oracle.
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 |
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
MySQL Client
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. Here is a brief example of logging in and creating a table:
ktm5j@kurma ~ $ mysql -h mysql.cs.virginia.edu -u abc6de -p Enter password: Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 650764 Server version: 5.5.56-MariaDB MariaDB Server Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. MariaDB [(none)]> CREATE DATABASE abc6de_Media -> ; Query OK, 1 row affected (0.00 sec) MariaDB [(none)]> show databases; +--------------------+ | Database | +--------------------+ | information_schema | | abc6de | | abc6de_Media | +--------------------+ 2 rows in set (0.00 sec) MariaDB [(none)]> CREATE TABLE abc6de_Media.Movies ( -> id int NOT NULL AUTO_INCREMENT, -> Title varchar(100) NOT NULL, -> ReleaseDate TIMESTAMP NOT NULL, -> CONSTRAINT Movies_PK PRIMARY KEY (id), -> CONSTRAINT Movies_UN UNIQUE KEY (Title) -> ) -> ENGINE=InnoDB -> DEFAULT CHARSET=latin1 -> COLLATE=latin1_swedish_ci; Query OK, 0 rows affected (0.00 sec) MariaDB [(none)]> use abc6de_Media Database changed MariaDB [abc6de_Media]> SHOW TABLES; +------------------------+ | Tables_in_abc6de_Media | +------------------------+ | Movies | +------------------------+ 1 row in set (0.00 sec) MariaDB [abc6de_Media]> INSERT INTO Movies(Title, ReleaseDate) VALUES ( 'The Usual Suspects', '1995-09-15'); Query OK, 1 row affected (0.00 sec) MariaDB [abc6de_Media]> SELECT * FROM Movies; +----+--------------------+-------------+ | id | Title | ReleaseDate | +----+--------------------+-------------+ | 1 | The Usual Suspects | 1995-09-15 | +----+--------------------+-------------+ 1 row in set (0.00 sec)
PHP
Our module for PHP was built with database support and drivers for MySQL.