CODEWITHSUNDEEP
mysqlmariadbremote-access
Cyberpunk7711
Cyberpunk7711

Reputation: 129

Making MYSQL users accessible via internet

My sql user is "mail" with host "localhost". If I change the host to "%", it is still not accessible via internet. The only difference is that I can no longer login on locally. Did I forget something? Error message:

MySQLNo connection could be made because the target machine actively refused it.

The firewall has already been deactivated as a test, but without success. Mariadb is configured by default. The operating system is debian. Restart of the service/server has also been done. If you need more detailed information, let me know. thanks for your attention

Upvotes: 2

Views: 78

Answers (1)

Gordan Bobić
Gordan Bobić

Reputation: 1888

I suspect you need to adjust this into your config:

bind-address = 0.0.0.0

As for "localhost", this means local socket. Try connecting to the server on 127.0.0.1 and it should let you in.

Upvotes: 2

Related Questions