← Back to MySQL Browser FAQs

How to Connect to a MySQL Database

The MySQL Browser supports two connection methods. Use whichever is more convenient.

Method 1: Connection URL (Scheme Mode)

  1. Open the MySQL Browser tool.
  2. Make sure the "Scheme" tab is selected.
  3. Paste your MySQL connection string:
mysql://username:password@host:3306/database_name

Click Connect. The tool will test the connection and load your tables.

Method 2: Individual Fields (Standard Mode)

  1. Switch to the "Standard" tab.
  2. Fill in the fields:
  • Host — your server address (e.g. localhost)
  • Port — usually 3306
  • Username — your database user (e.g. root)
  • Password — the user's password
  • Database — the database name

Click Connect to establish the connection.

Troubleshooting

  • Make sure your MySQL server allows remote connections if connecting from outside
  • Check that the user has the necessary privileges on the target database
  • For cloud databases, ensure your IP is whitelisted in the firewall or security group
  • Verify the port is correct — some providers use non-standard ports
  • If using special characters in the password, try the Standard mode instead of a URL