x/website: Tutorial Code: Error while connecting the MYSQL database.

[Omkar0114]

What is the URL of the page with the issue?

https://go.dev/doc/tutorial/database-access

What is your user agent?

Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36

Screenshot

What did you do?

I am following this Tutorial: Accessing a rational database
In the first place when we try to run the main.go to file with the below code

var db *sql.DB

func main() {
    // Capture connection properties.
    cfg := mysql.Config{
        User:   os.Getenv("DBUSER"),
        Passwd: os.Getenv("DBPASS"),
        Net:    "tcp",
        Addr:   "127.0.0.1:3306",
        DBName: "recordings",
    }
    // Get a database handle.
    var err error
    db, err = sql.Open("mysql", cfg.FormatDSN())
    if err != nil {
        log.Fatal(err)
    }

    pingErr := db.Ping()
    if pingErr != nil {
        log.Fatal(pingErr)
    }
    fmt.Println("Connected!")
}

many folks getting error when main.go file execute. the error getting is : This user requires MySQL native password authentication.

What did you expect to see?

I expect to see the MySQL database is connected with the Go code.

What did you see instead?

Instead of a connected database, I am getting this user requires MySQL native password authentication. this error and database connection is refused when we run main.go file.

[Omkar0114]

I tried to resolve this error, in config code below

cfg := mysql.Config{
        User:                 "root",
        Passwd:               "",
        Net:                  "tcp",
        Addr:                 "127.0.0.1:3306",
        DBName:               "recordings",
    }

If we add one more value AllowNativePasswords: true in the config code
the MySQL database is connecting.
Final code looks like this:

   cfg := mysql.Config{
        User:                 "root",
        Passwd:               "",
        Net:                  "tcp",
        Addr:                 "127.0.0.1:3306",
        DBName:               "recordings",
        AllowNativePasswords: true,
    }

[seankhliao]

Duplicate of #49134