Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision Last revision Both sides next revision | ||
|
mysql_server [2018/09/24 19:33] ktm5j created |
mysql_server [2020/08/27 15:48] pgh5a |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| - | ====== CS MySQL ====== | + | ==== MySQL server ==== |
| - | 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>. | + | 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 ===== | + | === Server Info === |
| + | |||
| + | === CS Department Server === | ||
| ^ Server | mysql.cs.virginia.edu | | ^ Server | mysql.cs.virginia.edu | | ||
| ^ TCP/IP Port | 3306 | | ^ TCP/IP Port | 3306 | | ||
| + | ^ phpMyAdmin | https://www.cs.virginia.edu/csdb | | ||
| - | 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. | + | === 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 ===== | ===== Accounts & Access ===== | ||
| Line 22: | Line 35: | ||
| abc6de_1 | abc6de_1 | ||
| </code> | </code> | ||
| + | |||
| + | ==== 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. | ||
| + | |||
| + | === PHP === | ||
| + | |||
| + | Our [[linux_environment_modules|module]] for PHP was built with database support and drivers for MySQL. | ||
| + | |||