Connect to a MySQL Database
This article covers 3 steps needed to connect to your hosted MySQL database. To connect to a Microsoft SQL Server Database click here.
Step 1: Install MySQL WorkBench
- Download and install the latest version of MySQL WorkBench
Step2: Find your Database Information
- Log in to your GearHost Account
- Click the Databases menu
- Locate the Database you want to connect to and click it to open the database details
- Note the server name for example
den1.mysql1.gear.host
, username and password (click on the "eye" icon to reveal your password)
Step 3: Connect to your database using MySQL Workbench
- Launch MySQL Workbench
- From the menu select Database > Connect to Database
- Enter the hostname with the database server name (see above)
- Leave the default port of 3306
- Enter your database username (see above)
- Click Ok
- When asked for your password enter it (see above)
- Click on the tile to connect to your database
If you have any questions let us know and open a support ticket.