Mymysql connection string for Mysql hosted on Azure #1077

New Issue

lunny · 2018-08-20T12:34:08Z

Ilanak commented

2018-08-20 12:34:08 +00:00

(Migrated from github.com)

I'm trying to connect to MySql DB hosted on Azure using mymysql driver.

I tried connecting using this connection string:
tcp:servername.mysql.database.azure.com:3306*dbname/username@servername/password

but i'm getting an error:
Received #9002 error from MySQL server: "SSL connection is required. Please specify SSL options and retry."

I tried adding ssl options, but I see that the only supported options are "ladder" and "timeout".

previously I used mysql driver with the following connection string and it worked:
username@servername:password@tcp(servername.mysql.database.azure.com:3306)/dbname?allowNativePasswords=true&tls=true

How can I enable the ssl option using mymysql?

I'm trying to connect to MySql DB hosted on Azure using mymysql driver. I tried connecting using this connection string: tcp:servername.mysql.database.azure.com:3306*dbname/username@servername/password but i'm getting an error: Received #9002 error from MySQL server: "SSL connection is required. Please specify SSL options and retry." I tried adding ssl options, but I see that the [only supported options](https://github.com/go-xorm/xorm/blob/11743c1a80897b0fdbf79d88ebcaa7dd5f9d3cf3/dialect_mysql.go#L592) are "ladder" and "timeout". previously I used mysql driver with the following connection string and it worked: username@servername:password@tcp(servername.mysql.database.azure.com:3306)/dbname?allowNativePasswords=true&tls=true How can I enable the ssl option using mymysql?

lunny commented

2018-08-20 14:14:33 +00:00

I'm not very familiar with this driver. You can go to https://github.com/ziutek/mymysql to find the options.