Question

How to connect golang application to managed mysql?

Posted November 3, 2021 94 views
MySQLGo

I’m working with digitalocean for the first time and I try to connect my golang application (set-up as an app incl. builds from gitlab) to a mysql dbase (as dbase cluster). The golang build is ok, and I can connect to the mysql database using mysql workbench on my local pc.

However, the application itself cannot access the managed mysql database (i added it to trusted sources). When the application tries to connect, I get the following error:

[ERROR] Unable to open database [default addr for network ‘private-xxxxxxxxxx-mysql-do-user-xxxxxxxx-0.b.db.ondigitalocean.com:25060’ unknown]

I tried using the default environment variable DATABASE_URL, as well as manually setting the connectstring (with of course the correct details):

user:password@private-xxxxxxxx-mysql-do-user-xxxxxxx-0.b.db.ondigitalocean.com:25060/dbase?ssl-mode=REQUIRED

Could it be that i have to install something else, or maybe another mysql client or install a certificate? Btw i used the github.com/go-sql-driver/mysql package in golang.

Any help is appreciated!

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
Submit an Answer
1 answer

oh i found the issue, it was the ssl-mode parameter that was not supported (used tls instead)