How to Connect MySql With Golang
Learn Data Science, Machine Learning and Artificial Intelligence for Free
Join Codersdaily
SUBSCRIBEAbout MySql
MySQL is currently one of the most well-known and widely used database technologies available to developers. It has a massive community, and it may power half of the internet as the primary database technology for WordPress.
Go-SQL-Driver
The Golang comes with this package which is lightweight and very fast and supports connections over 'TCP/IPv6 and IPv4 protocols'.
Now import the MySql driver using the following command
go get github.com/go-sql-driver/mysql
Connecting to the MySql Server
We can connect to the MySql server with the following program, but before jumping into that we are going to need a database object to which we can connect the server and checks the connection. creating a database object.
db, err := sql.Open("mysql", "<user>:<password>@tcp(127.0.0.1:3306)/<database-name>")
replace "username" with yours and password also, add your database name that has been created in local machine to check the MySql server.
package main
import (
"database/sql"
"fmt"
_ "github.com/go-sql-driver/mysql"
)
func main() {
//creating a database which will the connection
db, err := sql.Open("mysql", "root:passwd@tcp(0.0.0.0:3306)/user")
//for errors
if err != nil {
panic(err)
}
//method ping returns error if it face some trouble while connecting
err = db.Ping()
if err != nil {
panic(err)
}
fmt.Print("Done!")
defer db.Close()
}
outputs:
Done!