Reaching the CYAN server (in Mac OS)

The MicroAge Lab maintains a server, CYAN, for some of its courses. The server is often used to teach database principles.

Students in the associated current-term classes can log in to the server from campus networks. That is, UAWiFi, via the UA VPN, or by using computers physically plugged in to UA campus networks.

Connecting to CYAN from a Mac

Download and install MySQL Workbench

As a first step, if your computer does not have MySQL Workbench, you must download and install it. It is free and available from MySQL's website: https://dev.mysql.com/downloads/workbench/

Your computer screen will look like below screenshot:

MySql Download

Hit the download button.

In MySQL Workbench, create a connection entry for our CYAN server

After you have downloaded and installed MySQL Workbench, you can begin setting up a connection to our server.

1.  Open MySQL Workbench. It will open to a screen like this one: 

MIS CYAN Server - Login Blank Page

2.  Click on the plus sign icon in the MySQL Connections area to add a new connection: 

MIS cyan Server: Login Screen for MySQL Workbench 

3.  In the Setup New Connection window, fill in the following values:

Parameters required to setup a new MySQL connection to Cyan Server

Ensure Require is set for the Use SSL option when connecting to Cyan Server

Ensure that Enable Cleartext Authentication Plugin is selected

    1. Connection Name: you can use whatever you like that you will remember for this connection. We recommend MIS CYAN server.
    2. Connection Method: Select Standard (TCP/IP) from the dropdown.
    3. In the Parameters Area
      1. Hostname: mis-cyansrv.microagelab.arizona.edu
      2. Username: <Your NetID>
    4. Click on the SSL tab to bring up those options
      1. Ensure the Use SSL option dropdown shows Require.
    5. Click on the Advanced tab to bring up those options
      1. Click the checkbox for the option Enable Cleartext Authentication Plugin to enable that feature.
    6. When done, click OK to save the new connection.

Connect to CYAN using the connection entry you have made

Your new connection will appear in the MySQL Workbench window. Double-click the new connection to begin the connection process.

You will be prompted at least twice for password information. You will be using your NetID password.

Technical Support

If you experience issues connecting, the likely issue is where you are connecting from. The CYAN server is only open to UA campus networks; that is, UAWiFi (not UAGuest), UA VPN, and physical networks on the UA campus.

If you're trying to connect from a different network, you will need to use the UA's VPN server. Information about how to install and use it on a Windows computer is on UITS' VPN webpages. You will have to enroll in NetID+ to use the VPN.

If you are having trouble with your NetID credentials, please contact the UITS 24/7 Support Center at 520-626-TECH.

If you continue to have issues, please contact your course instructors for guidance, or the MicroAge Lab for technical assistance. You can submit a MicroAge Lab support request via our online form