mysql错误在单独的软件包中使用go-sql-driver拒绝用户访问

I am getting the following error when using with go-sql-driver with mysql and gorp when using in a separate package called dbutil Error 1045: Access denied for user 'root'@'localhost' (using password: NO)

package dbutil

import (
    "cropz/structs"
    "database/sql"
    "github.com/coopernurse/gorp"
    _ "github.com/go-sql-driver/mysql"
    "log"
)

func InitDB() *gorp.DbMap {
    // connect to db
    db, err := sql.Open("mysql", "root:pass@tcp(127.0.0.1:3306)/jsl")
    defer db.Close()

    err = db.Ping()
    checkErr(err, "Ping failed")

    // construct a gorp DbMap
    dbmap := &gorp.DbMap{Db: db, Dialect: gorp.MySQLDialect{"InnoDB", "UTF8"}}

    return dbmap
}


package main

func main() {

    dbmap := dbutil.InitDB()
    err := dbmap.Db.Ping()
    checkErr(err, "Ping failed")
}

If I have the initDB() function in the main package, it works fine.

This happens only if used with martini framework and dbutil in separate package. With martini framework and in the same package it still works.

I am using windows, MySQL-5.0.22. Please help.

thanks, Krishna

I deleted the .a files generated in the pkg folder and then didn't get the access denied error.

Your error looks like a login failure. Is your DSN setup appropriately?

Other than that you should remove the defer db.Close()

I believe you should only be closing the Db when you are actually done with it according to the spec.

When I run your code I actually get this error

panic: sql: database is closed