Connect to Remote MySQL database

This is a generalized set of instructions on how to connect to a MySQL database stored on a remote server using SSH. Currently these instructions were tested in Microsoft Windows using the application MySQL Workbench to connect to the Codd server but should work for other operating systems and servers that support MySQL Workbench.

Connect using MySQL Workbench

Microsoft Windows

  1. Download and install MySQL Workbench

    Download MySQL Workbench

  2. Start the MySQL Workbench application by going to Start → MySQL Workbench or typing mysql workbench into the Start Menu

  3. In the main window, go to Database → Connect to Database…

    Connect to Database

  4. In the Setup New Connection window…

    Add New Connection

    1. Under Connection Name, type the short name of the server: Codd
    2. Under Connection Method, select Standard TCP/IP over SSH
    3. Under SSH Hostname, type the full name of the server: codd.cs.gsu.edu
    4. Under SSH Username, type your GSU Username
      Example: jdoe23
    5. Under SSH Password, click Store in Vault…, then type your GSU Password and click OK

      Store SSH Password

    6. Under MySQL Hostname, keep the default value: 127.0.0.1
    7. Under MySQL Server Port, keep the default value: 3306
    8. Under Username, type your GSU Username
    9. Under Password, click Store in Vault…, then type the password for your database and click OK
      Note: Please speak with your professor for your current database password.

      Store MySQL Password

    10. Click Test Connection; you should see the following window upon a successful test:

      Test Connection

    11. If the test was successful, click OK

  5. You may now connect to the database by double-clicking the Codd entry under MySQL Connections.

Apple macOS

See Windows Instructions

The MySQL Workbench applications works similarly in different operating systems. Please see the Microsoft Windows instructions for more information.

Ubuntu Linux

See Windows Instructions

The MySQL Workbench applications works similarly in different operating systems. Please see the Microsoft Windows instructions for more information.

Need More Help?

This technology or service is under the support of the Computer Science department. If you are having any technical issues with the system, please consult your professor. You may also report an issue to the help desk.

Open a Support Ticket

  • Last modified: 2024/03/19 18:58