Re: [go-nuts] How to refresh database/sql MySQL connection username and password

2024-07-29 Thread Robert Engels
I am fairly certain the reconnection details, etc will be driver specific.  Many dbs will not drop the current connections when changing passwords - only used when a new connection is created. The easiest solution is to set the max connection lifetime on the pool, and change the password there to m

[go-nuts] How to refresh database/sql MySQL connection username and password

2024-07-29 Thread prasa...@gmail.com
I have a long running daemon written in Go, that listens to a port and spins up multiple go routines for every new connection to handle the data. There is a global variable context that has db Conn(*sql.DB) that is assigned connection context returned by database/sql library’s open() function d