[error] failed to initialize database. No connection could be made because the target machine actively refused it.

[blaze-d83]

Hey GORM community,

I’m encountering an issue when trying to connect to my MySQL database using GORM. The error message I receive is:

[error] failed to initialize database, got error dial tcp 127.0.0.1:3306: connectex: No connection could be made because the target machine actively refused it.
Failed to Connectdial tcp 127.0.0.1:3306: connectex: No connection could be made because the target machine actively refused it.
exit status 1

Here's what I am trying to do:

package config

import (
	"log"

	"gorm.io/driver/mysql"
	"gorm.io/gorm"
)

var DB *gorm.DB

func InitDB() {

	connectionString := GetConnectionString()
	var err error

	DB, err = gorm.Open(mysql.Open(connectionString), &gorm.Config{})
	if err != nil {
		log.Fatal("Failed to Connect", err)
	}
}

Go version: 1.22.4
Database: MySQL
Environment: Windows 10

Any insights or suggestions would be greatly appreciated. Thanks in advance for your help!

[blaze-d83]

For anyone on Windows facing this issue, check in your services.msc whether MySQL / MySQL80 is running. If not, then start the service and this issue should be resolved.