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. | ||
+ |