search

geerlingguy / ansible-role-mysql

Ansible Role - MySQL
https://galaxy.ansible.com/geerlingguy/mysql/
MIT License
1.05k stars 861 forks source link

mysql_bind_address does not override all conf files #520

Closed Axelfoley85 closed 1 year ago

Axelfoley85 commented 1 year ago

After running this role with mostly default parameters, remote access was still blocked. After commenting both lines manually in /etc/mysql/mysql.conf.d/mysqld.cnf I was finally able to access from remote to my database.

root@db01 ~# grep -r "bind" /etc/mysql/
/etc/mysql/my.cnf:bind-address = 0.0.0.0
/etc/mysql/mysql.conf.d/mysqld.cnf:bind-address         = 127.0.0.1
/etc/mysql/mysql.conf.d/mysqld.cnf:mysqlx-bind-address  = 127.0.0.1