1、安装mysql ssh包
go get github.com/g-shifu/go-mysql-ssh
2、设置远程mysql的地址 端口账号等信息和ssh地址、账号、密码即可(USE_SSH=true时ssh端口等信息不设置也可以,运行时会提示输入)
package main
import (
"fmt"
"github.com/g-shifu/go-mysql-ssh/pkg"
)
func main() {
//init
cfg := pkg.NewConfig()
cfg.DB_HOST = "your mysql host"
cfg.DB_USER = "your mysql username"
cfg.DB_PASS = "your mysql password"
cfg.DB_SELECT = "select database"
cfg.USE_SSH = true
cfg.SSH_REMOTE = "ssh remote address"
cfg.SSH_USER = "ssh user"
cfg.SSH_PASS = "ssh password"
pkg.InitDB(cfg)
//test
rtn, err := pkg.DBQueryRows("show tables;")
fmt.Println(rtn, err)
//close database
defer pkg.CloseDB()
}