# How to Connect to MySQL Database on the CCI Server

Please consult this <a href="
https://wiki.cci.arts.ac.uk/books/it-computing/page/how-to-connect-to-the-cci-server">article</a>, if you don't know how to connect to the CCI Server.
# Download and install MySQL Workbench
MySQL Workbench is a convenient GUI that helps you work with MySQL databases.
<ol>
  <li> This <a href="https://dev.mysql.com/downloads/workbench/">link</a> will take you to the MySQL Workbench's download page.
  <li> Click on the download button.
  <li> In case you don't have an Oracle account, you will need to create one (you can use your university email).
  <li> Download and install MySQL Workbench.
</ol>

# Connecting MySQL Workbench to CCI Server
<ol>
  <li> Open <b>Connect to Database</b> window, by clicking Database > Connect to Database.   
  <img src="https://github.com/locsor/imagesForWiki/blob/main/17.png?raw=true">
  <li> Name the connection as CCI Server or something similar
  <li> For the Connection Method select <b>Standard TCP/IP over SSH.</b>
  <li> <b>SSH Hostname:</b> cci.arts.ac.uk:2020
  <li> <b>SSH Username:</b> use the one you use to connect to the SSH server.
  <li> <b>SSH Password:</b> use the one you use to connect to the SSH server.
  <li> <b>SSH Key File</b> can be found here /Users/username/.ssh/id_rsa (.ssh is a hidden folder)
  <li> <b>MySQL Hostname:</b> 127.0.0.1
  <li> <b>MySQL Server Port:</b> 3306
  <li> <b>Username and Password:</b> use the same as SSH Hostname and SSH Password.
</ol>

# Check if you are connected
The simplest way to check that you are connected is to check the server status. If the server is running you are good to go!
<img src="https://github.com/locsor/imagesForWiki/blob/main/18.png?raw=true">