1. Home
  2. Databases
  3. Connecting to an ACC Database from MySQL Workbench

Connecting to an ACC Database from MySQL Workbench

You can use MySQL Workbench to access a SQL database created in the ACC. MySQL Workbench is a visual, user-friendly designed as an alternative for people who don’t want to use the terminal/command prompt to access their databases.

Setting Up Your Connection in MySQL Workbench

  1. Open the MySQL Workbench application
  2. On the welcome page, click the plus button next to MySQL Connections
    • plus button photo
  3. Fill in the information on the Setup New Connection form:
    • Connection Name: This is how you will identify the connection in MySQL Workbench. Since this is only a name in your personal MySQL Workbench application, you can name it whatever you want.
    • Connection Method: This is the method used to establish a connection. Select Standard TCP/IP over SSH.
    • SSH Hostname: This is your ACC server name. It will always be ACCusername.pairserver.com. Replace ACCusername with the username you use to log into your ACC account.
    • SSH Username: This is your ACC username. It is the same username you use to log into your ACC.
    • SSH Password: This is your ACC password. This is the same password you use to log into your ACC account.
    • SSH Key File: If you have a private key file, you can list the file path here. If you do not, leave this blank.
    • MySQL Hostname: This is the database’s MySQL server. You can find out what your database’s server is by following the instructions in our article, Finding Your Database Server Name.
    • MySQL Server Port: This is the port MySQL Workbench will use to connect to the server. It is usually 3306 or 3307.
    • Username: This is your database username. Refer to our article, How to Find Your Database Username, for more information on how to find your database username.

    • Password: This is the password you assigned to your database. If you haven’t created a password yet, the database will have a random password that will keep you from connecting. Go to our article, Changing an ACC Database Password, to find out how to change the password.

    • Default Schema: You can set a default database here. Leave this blank if you want to do this later.

  4. Click Test Connection when finished.
  5. A pop-up window will tell you if your connection was successful. If it was not, double check that your MySQL Hostname, Server port, Username, and Password are correct
  6. If your connection was successful, click OK

Your connection is now set up! You can use MySQL Workbench to easily create, delete, and edit your databases on your local machine.

Updated on May 4, 2018

Was this article helpful?

Related Articles