Show Posts
1
Database / remote access to mysql
« 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!
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!