Connect to MySQL with MySQL Workbench

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

  1. Click the ➕ (Plus) icon next to MySQL Connections
  2. Fill in the connection details:
FieldValue
Connection NameAny friendly name (e.g., My Website DB)
Connection MethodStandard (TCP/IP)
HostnameYour MySQL server (e.g.  myxx.winhost.com)
Port3306 (unless specified otherwise)
UsernameYour MySQL username
PasswordClick Store in Keychain / Vault and enter password
Default Schema(Optional) Your database name
Click OK to save.

Step 3: Test the Connection

  1. Click the newly created connection
  2. Enter the password if prompted
  3. 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:
  • Schemas panel (left)
  • SQL Editor
  • Server status & management tools

Step 5: Select a Database (Schema)

If a default schema wasn’t set:
  1. Expand Schemas
  2. Right-click your database
  3. Select Set as Default Schema