remote access to mysql

[adi]

Hello

New to Nedi
I am trying to access the mysql database from a remote host. I get connection error when I use the standard port and user name and passwort, which all works fine internally.

It seems I need to allow acccess to the DB from a remote server.
I searched and find this:

/etc/mysql/mariadb.conf.d#
 
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address            = 127.0.0.1

should I comment out the bind-address ?

Thanks!

[ascii]

you need to replace the ip with the actual ip of the server
but keep in mind haven a DB reachable from "anywhere" is a big security risk.
i would recommand to implement a firewall to controll acces to the db.