Can't load golang values ​​into mysql database. how to solve it?

Question

MySQL

package main

import (
    "database/sql"
    "fmt"

    _ "github.com/go-sql-driver/mysql"
)

func main() {

    db, err := sql.Open("mysql", "mysql:[email protected](127.0.0.1:3306)/golang")
    if err != nil {
        panic(err)
    }
    defer db.Close()

    insert, err := db.Query("INSERT INTO 'users' ('name', 'age') VALUES('alex', 43)")
    if err != nil {
        panic(err)
    }
    defer insert.Close()

    fmt.Println("ok")
}

here is the code, it gives an error,

but if you remove the second part of the code

insert, err := db.Query("INSERT INTO 'users' ('name', 'age') VALUES('alex', 43)")
    if err != nil {
        panic(err)
    }
    defer insert.Close()

everything is fine

, tell me what the problem is and how to solve
it, the database itself

is all local

Answer 1

Your MySQL service is not running or MySQL is not listening to localhost:3306

Answer 2

I don't know Go, but this is why (in the place where it stands): defer db.Close()?