Z is an experimental web server maintained by CS staff. It operates independently from the production CS server on www.cs.utexas.edu. It sometimes appears under the alternate name zweb.cs.utexas.edu.
Anyone with a current CS Unix account.
The extra features provided by this server have long ago been migrated to the CS production web server. This server should be considered deprecated, and is supported only for migration and redirection purposes.
Request a MySQL account here. Specify a database name which you want to create. Your MySQL login name will be the same as your CS Unix login name.
No. Z has no non-staff shell accounts, similar to the CS production web server.
The sole purpose of the MySQL server is to support http applications on z. As such, you should be able to administer MySQL from your http application. (This is basically a security policy -- I don't want to make a MySQL server visible to the endless stream of portscans, so 3306/tcp is blocked at the router).
All of the utilities in the MySQL distribution are available, and you can use them from any CS host. These tools should provide all the necessary MySQL access which one might need.
Connect with the mysql client and use set password, i.e.
mysql -h z -p -u LOGIN
where LOGIN is your CS Unix (and MySQL) login name. Then at the mysql prompt:
mysql> set password = password('NEW-PASSWORD');
where NEW-PASSWORD is your new MySQL password. It is not advisable to use your Unix password as a MySQL password.
Long, cute hostnames are overrated. :)