I was trying to run mysql server on 127.0.0.2, by default it is running in localhost. I changed the value of --bind-address to 127.0.0.2 in this file/usr/local/etc/my.cnf.
# Default Homebrew MySQL server config
[mysqld]
# Only allow connections from localhost
bind-address = 127.0.0.2
mysqlx-bind-address = 127.0.0.1
And then I did homebrew services restart mysql, but server is not running. Can anyone please help.
Also have user with host as above ip address, but not connecting.