...
If you want to allow connection from other external servers, you need to modify /usr/local/Cellar/mysql/8.0.19/homebrew.mxcl.mysql.plist and bind-address=0.0.0.0 as following:
...
Start MySQL
Code Block |
---|
sudo /usr/local/mysql/support-files/mysql.server start brew services start mysql |
Stop MySQL
Code Block |
---|
sudo /usr/local/mysql/support-files/mysql.server stop brew services stop mysql |
Restart MySQL
Code Block |
---|
sudo /usr/local/mysql/support-files/mysql.server restart brew services restart mysql |
Set root access permission from all hosts
...