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.

Recent posts