​
Connect to MySQL

Galaxy makes it easy to connect to your MySQL database and start querying in seconds.

​
Quick Start

  1. Click Add Source in Galaxy
  2. Select MySQL from the list
  3. Fill in your connection details
  4. Test the connection
  5. Start querying!

​
Connection Details

Create MySQL Source When creating a MySQL connection, you’ll need:
​
name
string
required
A friendly name for your connection Example: Production DB or Analytics MySQL
​
host
string
required
Your MySQL server address Example: localhost or db.example.com
​
port
number
default:"3306"
required
The port number (usually 3306)
​
username
string
required
Your database username Example: root
​
password
string
required
Your database password
​
database
string
required
The database name to connect to Example: mysql

​
Testing Your Connection

Before saving, Galaxy will test your connection to make sure everything works. Click Test Connection to verify your settings.

​
Success

Connection Successful When successful, you’ll see a green confirmation message and can save your connection.

​
Error

Connection Error If there’s an issue, you’ll see an error message with details about what went wrong.

​
Common Issues

​
Connection Failed

  • Double-check your host and port
  • Verify your username and password
  • Make sure your database allows external connections
  • Check if you’re behind a VPN or firewall

​
Authentication Error

  • Confirm your username has access to the database
  • Verify your password is correct
  • Check if your MySQL server uses a different authentication method
  • Ensure your MySQL version is compatible

​
Port Issues

  • Default MySQL port is 3306
  • Check if your MySQL server is configured to use a different port
  • Verify firewall rules allow connections on the MySQL port

​
Next Steps

Once connected, you can:
  • Browse your tables and schemas in the sidebar
  • Write SQL queries with auto-complete
  • Use the AI agent to help write queries
  • Save and share your queries with your team