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.
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.
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.
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.
Refer to Troubleshooting MySQL Connections for more information.