Use MySQL Workbench to Access a Database
Use MySQL Workbench to create, execute, and optimize SQL queries.Discuss in our Forum Discuss in Slack
This section provides information on how to use MySQL Workbench to access a database on Pantheon.
MySQL Workbench provides database administrators and developers with integrated tools for:
Database design and modeling
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 sites Dashboard. Refer to Accessing MySQL database for detailed information.
Create a New MySQL Connection
Start MySQL Workbench and click the + icon on the top left of the screen to create a MySQL connection.
Enter the information to connect to the database. The following fields 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
Click Test Connection to initiate a connection with the remote database after you complete the steps in the section above.
- You'll receive a confirmation message if it succeeds.
Confirm that the new connection is available on the MySQL Workbench workspace after the configuration completes.
Connect to the Database
You can now administer your database. There will be a new entry on the Workbench for the newly configured connection and you can click the icon to initiate a session.
Troubleshooting MySQL Connections
Refer to Troubleshooting MySQL Connections for more information.