Using MySQL Workbench to Access a Database
Detailed information on using MySQL Workbench for creating, executing, and optimizing SQL queries.
MySQL Workbench provides DBAs and developers an integrated tools environment for: database design & modeling; SQL development; database administration; and support for Windows, Mac OS X, and Linux.
Start by getting the MySQL connection for the environment you want to access. To get the database credentials, copy them from the Connection Information widget available on the site's Dashboard. For detailed information, see Accessing MySQL database.
Create a New MySQL Connection
Now that you have the credentials for the database handy, you can start MySQL Workbench and set up your connection. Once the application has started, click the + icon on the top left of the screen to create a MySQL connection. Next, enter the information to connect to the database. Each of the following are required:
Connection Name - A unique name (add a prefix for Dev/Test/Live)
Connection Method - Standard (TCP/IP)
Hostname - MySQL database hostname
Username - MySQL database username
Port - MySQL database port (tip: Remember this value)
Password - The password on the dashboard's connection info
Click the Store in Keychain... button and enter your MySQL password for the environment.
Ensure you have the correct database username and password for your environment.
Test the Database Connection
After entering all the information, click Test Connection to initiate a connection with the remote database. If it succeeds, you'll receive a confirmation message.
After the configuration is complete, the new connection will be available on the MySQL Workbench workspace.
Connect to the Database
At this point, you are all set and can administer your database. There will be a new entry on the Workbench for the newly set up connection and you can click the icon to initiate a session.