如何使用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(127.0.0.1:3306)/test")

//tried 172.17.0.1:3306 and 172.17.0.2:3306

and this is my container's network info

"Networks": {
            "bridge": {
                "IPAMConfig": null,
                "Links": null,
                "Aliases": null,
                "NetworkID": "47b2a5c798522f5eb6688c4540b4017335eb174528d510b9f1d35d125313017c",
                "EndpointID": "ca2256684928e4184efd36f880cd70d3809d79db5b30c10ab37c66ccbbbba610",
                "Gateway": "172.17.0.1",
                "IPAddress": "172.17.0.2",
                "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

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

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

  db，err：= sql.Open（“ mysql”，“ root：welcome @ / tcp（127.0.0.1：  3306）/ test“）
  code>  pre> 
 
  //尝试172.17.0.1:3306和172.17.0.2:3306  p> 
 
 
 是我的容器的网络信息 p> 
 
 
 “网络”：{
“ bridge”：{
“ IPAMConfig”：null，
“ Links”：null，
“ 别名”：空，
“网络ID”：“ 47b2a5c798522f5eb6688c4540b4017335eb174528d510b9f1d35d125313017c”，
“端点ID”：“ ca2256684928e4184efd36f880cd70d3809d79db5b30c10ab37c66ccbcbabba610”。  n“ IPPrefixLen”：16，
“ IPv6Gateway”：“”，
“ GlobalIPv6Address”：“”，
“ Gl  obalIPv6PrefixLen“：0，
” MacAddress“：” 02：42：ac：11：00：02“ 
} 
} 
  code>  pre> 
 
 我不是 确定我应该提供哪些信息以获得正确答案，因为我是vm  p> 
  div>的新手

答

Your connection is wrong, use

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

Notice that "/" is removed after "@"

The README says a valid connection path is like

[username[:password]@][protocol[(address)]]/dbname

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

相关推荐