Prerequisites
Step 1: Open MySQL Workbench
Launch MySQL Workbench.
You’ll land on the Home screen under MySQL Connections.
Step 2: Create a New Connection
Click the ➕ (Plus) icon next to MySQL Connections
Fill in the connection details:
| Field | Value |
|---|
| Connection Name | Any friendly name (e.g., My Website DB) |
| Connection Method | Standard (TCP/IP) |
| Hostname | Your MySQL server (e.g. myxx.winhost.com) |
| Port | 3306 (unless specified otherwise) |
| Username | Your MySQL username |
| Password | Click Store in Keychain / Vault and enter password |
| Default Schema | (Optional) Your database name |
Click OK to save.
Step 3: Test the Connection
Click the newly created connection
Enter the password if prompted
Click Test Connection
✅ If successful, you’ll see “Successfully made the MySQL connection.”
Step 4: Connect to the Database
Double-click the connection to open it.
You’ll now see:
Step 5: Select a Database (Schema)
If a default schema wasn’t set:
Expand Schemas
Right-click your database
Select Set as Default Schema
Article ID: 832, Created: 8/16/2010 at 2:43 PM, Modified: 1/28/2026 at 12:06 PM