mysql://foo:bar@localhost/search/?dbmode=single

  my $url = Mojo::MySQL5::URL->new('mysql://sri:foo@server:3306/test?foo=bar');

The general format for a JDBC URL for connecting to a MySQL server is as follows, with items in square brackets ([ ]) being optional:

jdbc:mysql://[host1][:port1][,[host2][:port2]]...[/[database]] »

[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]

Here is a simple example for a connection URL:

jdbc:mysql://localhost:3306/sakila?profileSQL=true

The following is an alternate format for JDBC URLs connecting to a MySQL server, which is mandatory for IPv6 connections, but can also be used with IPv4 (items in square brackets ([ ]) are optional):

jdbc:mysql://address=(key1=value)[(key2=value)]...[,address=(key3=value)[(key4=value)]...]...[/[database]]»

[?propertyName1=propertyValue1[&propertyName2=propertyValue2]...]

Supported key-value pairs include:

(protocol=tcp), or (protocol=pipe) for named pipes on Windows.

(path=path_to_pipe) for path of named pipes. Default value for the path is \\.\pipe\MySQL. Use the key-value pair to specify a custom named pipe.

(host=hostname) for TCP connections.

(port=port_number) for TCP connections.

For example:

jdbc:mysql://address=(protocol=tcp)(host=localhost)(port=3306)/db

In addition to passing these options as an object, you can also use a url string. For example:

var connection = mysql.createConnection('mysql://user:pass@host/db?debug=true&charset=BIG5_CHINESE_CI&timezone=-0700');

Note: The query values are first attempted to be parsed as JSON, and if that fails assumed to be plaintext strings.

if (url.query) {

for (var key in url.query) {

var value = url.query[key];

try {

// Try to parse this as a JSON expression first

options[key] = JSON.parse(value);

} catch (err) {

// Otherwise assume it is a plain string

options[key] = value;

}

}

}

# default

engine = create_engine('mysql://scott:tiger@localhost/foo')

# mysql-python

engine = create_engine('mysql+mysqldb://scott:tiger@localhost/foo')

# MySQL-connector-python

engine = create_engine('mysql+mysqlconnector://scott:tiger@localhost/foo')

# OurSQL

engine = create_engine('mysql+oursql://scott:tiger@localhost/foo')

mysql+mysqldb://<user>:<password>@<host>[:<port>]/<dbname>

mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<projectid>:<instancename>

mysql+pymysql://<username>:<password>@<host>/<dbname>[?<options>]

mysql+mysqlconnector://<user>:<password>@<host>[:<port>]/<dbname>

mysql+cymysql://<username>:<password>@<host>/<dbname>[?<options>]

mysql+oursql://<user>:<password>@<host>[:<port>]/<dbname>

mysql+mysqldb://root@/<dbname>?unix_socket=/cloudsql/<projectid>:<instancename>

mysql+gaerdbms:///<dbname>?instance=<instancename>

mysql+pyodbc://<username>:<password>@<dsnname>

mysql+zxjdbc://<user>:<password>@<hostname>[:<port>]/<database>

You can retrieve your new ClearDB database URL by issuing the following command:

$ heroku config | grep CLEARDB_DATABASE_URL

CLEARDB_DATABASE_URL => mysql://adffdadf2341:adf4234@us-cdbr-east.cleardb.com/heroku_db?reconnect=true

To set your DATABASE_URL to the value of CLEARDB_DATABASE_URL, simply issue the following heroku command. For example:

If you’re using the mysql2 gem, you will need to change the mysql:// scheme in the CLEARDB_DATABASE_URL to mysql2://

To instantiate a JDBC connection in your code, you can use a method like this:

private static Connection getConnection() throws URISyntaxException, SQLException {

URI dbUri = new URI(System.getenv("CLEARDB_DATABASE_URL"));

String username = dbUri.getUserInfo().split(":")[0];

String password = dbUri.getUserInfo().split(":")[1];

String dbUrl = "jdbc:mysql://" + dbUri.getHost() + dbUri.getPath();

return DriverManager.getConnection(dbUrl, username, password);

}

MySQL (GIS) django.contrib.gis.db.backends.mysql mysqlgis://USER:PASSWORD@HOST:PORT/NAME

MySQL django.db.backends.mysql mysql://USER:PASSWORD@HOST:PORT/NAME

MySQL (GIS) django.contrib.gis.db.backends.mysql mysqlgis://USER:PASSWORD@HOST:PORT/NAME

DATABASE_URL="mysql2://username:password@host/database"

If you want to use UNIX sockets with the Mysql JDBC Connector/J you need to provide a socketFactory.

jdbc:mysql:///?user=test&password=test&socketFactory=<classname>&<socket>=/tmp/mysql.sock

So this will vary with the implementation you use. By default, Mysql does not ship with any implementation for that, just provides an example for such a factory in it's source-code.

As another answer pointed out, it's possible (at least in Intellij IDE) to use socket connection for Mysql JDBC Connector/J (I am using version 5.1) without having to provide a socketFactory,

jdbc:mysql://localhost:3306/database_name?socket=/tmp/mysql.sock

The JDBC Driver from the MariaDB project supports Unix domain sockets while remaining compatible with the MySQL Connector/J JDBC driver. Example jdbc url for the MariaDB driver is: jdbc:mariadb://localhost:3306/revmgt?localSocket=/var/run/mysqld/mysqld.sock

mysql -> MySQL (for MySQL <= 4.0)

mysqli -> MySQL (for MySQL >= 4.1) (requires PHP 5) (since DB 1.6.3)

To specify the socket file for MySQL, you need to use the unix_socket option:

mysql://localhost/database?unix_socket=/var/lib/mysql/socket