Differences

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

Link to this comparison view

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.
 +
  • mysql_server.1537817638.txt.gz
  • Last modified: 2018/09/24 19:33
  • by ktm5j