NeDi Community

NeDi Software Specific => Database => Topic started by: adi on February 12, 2020, 09:52:52 pm

Title: remote access to mysql
Post by: adi on February 12, 2020, 09:52:52 pm
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!
Title: Re: remote access to mysql
Post by: ascii on February 13, 2020, 11:02:22 am
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.