Welcome, Guest. Please login or register.

Author Topic: remote access to mysql  (Read 1901 times)

adi

  • Newbie
  • *
  • Posts: 1
    • View Profile
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!

ascii

  • Full Member
  • ***
  • Posts: 107
    • View Profile
Re: remote access to mysql
« Reply #1 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.