Skip to main content

URLs

What is a URL?

Uniform Resource Locators, or URLs are a standardized method for specifying a location of a resource. All the component parts of a URL are shown below:

driver://[username[:password]@]address/[schema|database][?param1=value1&...&paramN=valueN]

An example might look like:

Connecting to a local MySQL server (all schemas/databases):

mysql://localhost:3306/

Connecting to a specific MySQL schema (database) with a username and password:

mysql://user:pass@localhost:3306/schema

Connecting using Unix Sockets:

mysql+unix:///tmp/mysql.sock

mysql+unix://user:pass@/tmp/mysql.sock

mysql+unix://user@/tmp/mysql.sock?database=dbname

SSL/TLS Mode

The default SSL mode for Postgres is required. Please follow the Postgres documentation for configuring your SSL connection for your database, or set SSL mode to disable with the search parameter ?sslmode=disable. For local databases, disabling SSL is appropriate when inspecting and applying schema changes.

MySQL does not require TLS by default. However, you can require TLS with the ?tls=true search parameter.