Breadcrumbs

Home Technical Help Using MySQL Workbench to Connect to hosted database over TCP/IP
Using MySQL Workbench to Connect to hosted database over TCP/IP PDF Print E-mail
Written by Administrator   

1. Open MySQL workbench

2. Click on New Connection

3. In the next window that appears enter the following:
Connection Name:  any name
Hostname: hostname for the MySQL database host from your hosting provide
Username: database username
Password: click on store in vault and enter password

4. Once the connection is established double click the connection

5. In the SQL Editor tab. You will need to set a default schema to edit or run queries on the database. To do this follow the below instructions.

6. Click on database > Manage Connections

7. In the tab that appears enter the Default Schema: enter the database name