![mysql workbench connect to online database mysql workbench connect to online database](https://i.stack.imgur.com/qOy85.png)
Get help from the PlanetScale support team, or join our GitHub discussion board to see how others are using PlanetScale. The following MySQL GUI applications have been tested and confirmed to work with PlanetScale databases: Creating new databases is not supported using any GUI tool.However, DDL is supported on development branches and production branches without safe migrations enabled (not recommended). Production branches with safe migrations enforce the use of branching and deploy requests to safely make schema changes and do not support direct DDL as a result.You'll need separate connection details per branch.
![mysql workbench connect to online database mysql workbench connect to online database](http://i.stack.imgur.com/jKDJG.png)
![mysql workbench connect to online database mysql workbench connect to online database](https://i.ytimg.com/vi/Jgkac9DPSis/maxresdefault.jpg)
As well as enabling you to configure connection parameters, MySQL Workbench provides the capability to execute SQL queries on the database connections using the built-in SQL Editor. Each branch of a PlanetScale database is considered an isolated MySQL database. Third step to connect to the server: Write the following code: conn (host you host name like localhost or 127.0.0.1, username your username like root, password your password) Third step Making the cursor: Making a cursor makes it easy for us to run queries. MySQL Workbench provides five main areas of functionality: SQL Development: Enables you to create and manage connections to database servers.While many standard MySQL statements are supported, there are a few caveats worth calling out: If the connection is successful, you should be able to query your database and perform other supported operations. Make sure to check "Require SSL" as SSL is required to connect to a PlanetScale database. In the application you are using, enter the access information you gathered in the previous step into the appropriate fields. If you do not know the password, you may generate a new credential set by clicking the "New password" button in the Connect modal. As a security best practice, passwords are only displayed when they are created.