Cannot connect to MySQL about nvim-dbee HOT 3 CLOSED

@kndndrj Ah, ok, great, thank you ❤️

So the correct format for MySQL seems to be (for my non-standard 13306 port):

{
  name = "whatever - refers to the connection, not the database",
  type = "mysql",
  ulr = "user:pass@tcp(0.0.0.0:13306)/mydbname"
}

Things that are unusual about the url field compared to other DSNs:

• there's no mysql:// at the start
• you need tcp(...) wrapping the address field. I think (untested) you'd need unix(...) for a socket.

The other thing that's noticable - may be a separate issue? - is that once you're 'in', the drawer shows:

(connection name) » structure » all databases

and allows you to toggle-open any database. But then you can't look at any tables in those databases because it says they don't exist in mydbname specified in the connection. It seems odd to show stuff that can't be accessed and it would be cleaner to show the selected/filtered/limited mydbname as selected/opened somehow.

Anyway, thanks, I'm set up now and will continue testing.

from nvim-dbee.

Hey, I'm not sure if url is correct or not, but can you please refer to mysql go driver's readme and check if they use some sort of special naming? https://github.com/go-sql-driver/mysql#dsn-data-source-name

Please try it and let me know if it helped :)

from nvim-dbee.

url = "user:pass@tcp(0.0.0.0:13306)/mydbname"

This doesn't seem to work anymore. The client now attempts to parse it as an actual URL, and it's not a valid url:

https://github.com/kndndrj/nvim-dbee/blame/09a15121eb26a9845c5a961beb2a17285a5d1eee/dbee/clients/mysql.go#L28

from nvim-dbee.