MySQL Connection String Builder

#What this tool does

Fill in your host, port, database, username, password, and SSL settings. Get connection strings in three formats: URL (mysql://), JDBC (jdbc:mysql://), and DATABASE_URL (the env var convention used by Rails, Django, Express, and PaaS platforms). Special characters in passwords are percent-encoded automatically.

Need PostgreSQL instead? Use the PostgreSQL Connection String Builder.

#Connection string formats

URL format — used by most ORMs and drivers:

mysql://user:pass@host:3306/dbname?ssl=true

JDBC format — for Java applications:

jdbc:mysql://host:3306/dbname?user=user&password=pass&useSSL=true

DATABASE_URL env var — the standard for containerized apps and Docker deployments, used by frameworks like Rails and Django:

DATABASE_URL="mysql://user:pass@host:3306/dbname"

#SSL modes

• DISABLED — no encryption. Don't use in production.
• REQUIRED — encrypted, no certificate verification. Default for most managed MySQL services.
• VERIFY_CA — verifies the server certificate CA.
• VERIFY_IDENTITY — verifies CA + hostname match. Most secure.

#Default ports

All MySQL-compatible databases use port 3306 by default.

#Open source

This tool is powered by @azin-tech/mini-tools, an open-source developer toolkit. View source on GitHub.