2016-11-21 19:38
浏览 261

如何使用go正确连接mysql docker容器?

I started to learn docker today and have big blocker. What I am trying to do is thatopen mysql connection using go-sql-driver/mysql.

I can connect mysql container using sequel pro with localhost:3306
However, it seems not working with go-sql-driver/mysql

db, err := sql.Open("mysql", "root:welcome@/tcp(")

//tried and

and this is my container's network info

"Networks": {
            "bridge": {
                "IPAMConfig": null,
                "Links": null,
                "Aliases": null,
                "NetworkID": "47b2a5c798522f5eb6688c4540b4017335eb174528d510b9f1d35d125313017c",
                "EndpointID": "ca2256684928e4184efd36f880cd70d3809d79db5b30c10ab37c66ccbbbba610",
                "Gateway": "",
                "IPAddress": "",
                "IPPrefixLen": 16,
                "IPv6Gateway": "",
                "GlobalIPv6Address": "",
                "GlobalIPv6PrefixLen": 0,
                "MacAddress": "02:42:ac:11:00:02"

I am not sure which info I should provide to get right answer since I am new to vm

图片转代码服务由CSDN问答提供 功能建议

我今天开始学习docker,并拥有强大的拦截器。 我想做的是使用go-sql-driver / mysql打开mysql连接。

我可以使用sequel pro与localhost:3306
连接mysql容器 似乎不适用于go-sql-driver / mysql

  db,err:= sql.Open(“ mysql”,“ root:welcome @ / tcp(  3306)/ test“)



“ bridge”:{
“ IPAMConfig”:null,
“ Links”:null,
“ 别名”:空,
“网络ID”:“ 47b2a5c798522f5eb6688c4540b4017335eb174528d510b9f1d35d125313017c”,
“端点ID”:“ ca2256684928e4184efd36f880cd70d3809d79db5b30c10ab37c66ccbcbabba610”。  n“ IPPrefixLen”:16,
“ IPv6Gateway”:“”,
“ GlobalIPv6Address”:“”,
“ Gl  obalIPv6PrefixLen“:0,
” MacAddress“:” 02:42:ac:11:00:02“ 

我不是 确定我应该提供哪些信息以获得正确答案,因为我是vm 的新手

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 邀请回答

1条回答 默认 最新

  • dsyo9700
    dsyo9700 2016-11-21 20:47

    Your connection is wrong, use

    db, err := sql.Open("mysql", "root:welcome@tcp(")

    Notice that "/" is removed after "@"

    The README says a valid connection path is like

    点赞 评论