installed mysql 8.0.17 via brew on osx 10.14.6
When i start mysqld (either directly or via brew services start mysql) i can see mysql process listening on both 127.0.0.1 and *.
The brew install output clearly mentioned that it would listen on localhost only.
The only config file i could find /usr/local/etc/my.cnf seems to be set that way:
$ cat /usr/local/etc/my.cnf # Default Homebrew MySQL server config [mysqld] # Only allow connections from localhost bind-address = 127.0.0.1 yet:
$ lsof -nP -i | grep LISTEN mysqld 123 user 28u IPv4 0x77334cb9760b9455 0t0 TCP 127.0.0.1:3306 (LISTEN) mysqld 123 user 31u IPv6 0x77334cb96cd76ed5 0t0 TCP *:33060 (LISTEN) i tried using mysqld --verbose but it doesn't mention which file is being used for config at all.
there is only that one mysql version installed. Confirmed by which and find.
1 Answer
it seems that is some sort of mysqlx plugin. not sure what that is used for or why it is enabled by default:
$ mysqld --verbose --help | grep bind bind-address 127.0.0.1 mysqlx-bind-address * After adding mysqlx-bind-address = 127.0.0.1 to my my.cnf lsof shows mysql listening only on localhost.
