Connect Mysql with GoLang

Connect Mysql with GoLang

    To connect mysql with GoLang 

    1. First go to your root folder of your project and run the command

    go get

       It should download the mysql package

       2. After that import mysql like below

    import (
    _ ""

      3. Then in your main function of Go program, you can initialize it like below

    db, err := sql.Open("mysql", "root:123456@tcp(")
    // if there is an error opening the connection, handle it
    if err != nil {
    defer db.Close()
    var tag Tasks
    // Execute the query
    err = db.QueryRow("SELECT id, task_name FROM tasks where id = ?", 2).Scan(&tag.ID, &tag.TaskName)
    if err != nil {
    panic(err.Error()) // proper error handling instead of panic in your app

     In the above code my password is 12345 and user name is root. And database name is task_managment. You need to change them as per your need..

     In the db.QueryRow you need to change the the table name based on your needs.