Differences
This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
mysql_server [2018/09/24 19:33] ktm5j created |
mysql_server [2020/08/27 15:49] (current) 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 | | ||
- | ===== Accounts & Access ===== | + | === 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. | 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. | ||
Line 22: | Line 35: | ||
abc6de_1 | abc6de_1 | ||
</code> | </code> | ||
+ | |||
+ | === 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. | ||
+ |