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
- Open the MySQL Workbench application
- On the welcome page, click the plus button next to MySQL Connections
- 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.
- Click Test Connection when finished.
- 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
- 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.