How do I connect to mysql server with Go and go-sql-driver?

Question

I am following the tutorials here and here but I am unable to connect to the test database that came with mySQL installation. I can connect to mySql through the command line. What am I missing? When I run the code below I get the error "cannot ping":

package main

import (
    "fmt"
    "database/sql"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "/test")
    if err != nil {
        fmt.Println(err)
        return
    }
    defer db.Close()

    err = db.Ping()
    if err != nil {
        fmt.Println("cannot ping")
        return
    } 
}

peterSO · Accepted Answer · 2013-07-10 01:50:42Z

2

For example, substitute your MySQL user name and password for the words user and password,

package main

import (
    "database/sql"
    "fmt"
    _ "github.com/go-sql-driver/mysql"
)

func main() {
    db, err := sql.Open("mysql", "user:password@/test")
    if err != nil {
        fmt.Println(err)
        return
    }
    defer db.Close()
    err = db.Ping()
    if err != nil {
        fmt.Println(err)
        return
    }
    fmt.Println("Ping")
}

Output:

Ping

edited Jul 10, 2013 at 1:50

answered Jul 10, 2013 at 1:35

peterSO

168k32 gold badges303 silver badges293 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Zeynel Over a year ago

Thanks for adding err in fmt.Println(err). I was not seeing what errors I was getting.

Collectives™ on Stack Overflow

How do I connect to mysql server with Go and go-sql-driver?

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related