Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
Last revision Both sides next revision
mysql_server [2018/09/24 19:56]
ktm5j
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>​.  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.+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 23: Line 36:
 </​code>​ </​code>​
  
-===== MySQL Client =====+==== 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.+All of our Linux servers and desktops should have the ''​%%mysql%%''​ command available. ​ 
  
-==== PHP ====+=== PHP ===
  
 Our [[linux_environment_modules|module]] for PHP was built with database support and drivers for MySQL. Our [[linux_environment_modules|module]] for PHP was built with database support and drivers for MySQL.
  
  • mysql_server.txt
  • Last modified: 2020/08/27 15:49
  • by pgh5a