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:new connection image
    • 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).
    • Hostname: This is your database's server. See our Finding Your Database Server Name article for instructions on how to find the server name.  
    • 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. See our How to Find Your Database Username article for instructions on how to find the 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.keychain image
    • Default Schema: You can set a default database here. Leave this blank if you want to do this later.

  4. Click the SSL tab in the Setup New Connection windowssl image
  5. Next to Use SSL, click the drop-down and choose Nossl no image
  6. Click Test Connection when finishedtest connection image
  7. 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
  8. If your connection was successful, click OK

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

Updated on February 5, 2019

Was this article helpful?

Related Articles