# RazorSQL

## Query, Edit, Browse, and Manage Databases

- razorsql.com
- Contact

# MySQL JDBC Driver and URL Information

Listed below are connection examples for MySQL: MySQL Connector/J Driver

DRIVER CLASS: com.mysql.jdbc.Driver
DRIVER LOCATION: Simply provide the location of the jar file containing
the MySQL JDBC Drivers. These drivers can be obtained from MySQL.
See the MySQL web site for more information.
Example: mysql-connector-java-3.1.11-bin.jar
JDBC URL FORMAT: jdbc:mysql://<host>:<port>/<database_name>
The default port for MySQL is 3306. Usually, if the default port
is being used by the database server, the :<port> value
of the JDBC url can be omitted.
ADDITIONAL JDBC CONNECTION PROPERTIES
Additional connection properties can be appended to the JDBC URL.
The format to add connection properties is the following:
jdbc:mysql://<host>:<port>/<database_name>?property1=value1&property2=value2
Here are examples of connection properties for the MySQL Connector/J driver.
Consult your driver documentation for more examples of connection properties.
connectTimeout (Timeout for socket connect (in milliseconds), with 0 being no timeout.
Only works on JDK-1.4 or newer. Defaults to 0.)
socketTimeout (Timeout on network socket operations (0, the default means no timeout).)
autoReconnect (Should the driver try to re-establish stale and/or dead connections.)
Examples:
jdbc:mysql://neptune.acme.com:3306/test
jdbc:mysql://127.0.0.1:3306/test
jdbc:mysql://localhost:3306/mysql?connectTimeout=0&socketTimeout=0&autoReconnect=true