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
mysql_server [2018/09/24 19:56]
ktm5j
mysql_server [2020/08/27 15:49]
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 |
  
-===== 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 23: Line 36:
 </​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.+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