Release External Mysql Connection

Question

I recently set up a mirrored Mysql server. Following this procedure: https://hostpresto.com/community/tutorials/how-to-setup-mysql-master-master-replication-on-ubuntu-16-04/

The command to release access has already been executed:

GRANT ALL ON . To root@%' IDENTIFIED BY 'Qwerty@123';

However the line in: $ sudo nano /etc/mysql/my.cnf

bind-address = 127.0.0.1

It’s preventing sternal connections!

How do I allow external connections once I’m mirroring with this procedure?

Answer 1

Change the bind-address to 0.0.0.0, which means "all network interfaces". The value 127.0.0.1 refers to the loopback network interface, which allows only local connection, on the server itself.