MySQL URL properties

Option Description Type Example
user The MySQL login ID. This property is required unless the auth-part of the URL was used String user=root
password The password for user. This property is required unless the auth-part of the URL was used String password=swordfish
connect-timeout Connect timeout in seconds. Default is 3 seconds. It is a checked error to use a value equal to or less than 0 Integer connect-timeout=5
compress Use the compressed client/server protocol. Default is false Boolean (true/false) compress=true
use-ssl Used for establishing secure connections using SSL. OpenSSL support must be enabled/linked in the client library. Default is false Boolean (true/false) use-ssl=true
charset Use this character set when communicating with the server. MySQL charsets, e.g. "utf8" or "latin1" String charset=utf8
secure-auth Whether to connect to a server that does not support the password hashing used in MySQL 4.1.1 and later. Default is false Boolean (true/false) secure-auth=true
unix-socket Connect to the database server over a unix socket on localhost. The unix-socket value should be the full path to the socket file. MySQL use default the file /tmp/mysql.sock. Note that this is different from the PostgreSQL unix-socket parameter which specify the full path to the directory where the socket file is located. String unix-socket=/tmp/mysql.sock

 


Copyright © 2011 Tildeslash Ltd. All rights reserved.