Mysql Connection Strings

"Mysql Connection String" samples.

Simple Mysql Connection String

mysql://username:password@localhost:3306

Mysql Connection String using DB_Name

mysql://username:password@localhost:3306/DB_Name?characterEncoding=UTF-8&serverTimezone=UTC&multipleStatements=true

Demo example:

mysql://test_user:test_password@127.0.0.1:3306/mysql?multipleStatements=true

Note: Please provide param 'multipleStatements=true' in mysql connection string. If you do not provide that param than some functionality can be affect.

username: DB Username.

password: DB Password.

localhost: Mysql server IP or DNS.

3306: Mysql server default port.

DB_Name: Is your mysql schema name.

characterEncoding: Which character encoding you want to use.

serverTimezone: Which timezone you want to use.

Ref_Link: Connection String URI Format