mysql远程访问

1、mysql -u root -p

 

2、grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;

 

flush privileges;

 

3、打开/usr/local/Cellar/mysql/5.7.16/下的homebrew.mxcl.mysql.plist文件，去掉

 

--bind-address=127.0.0.1

或0.0.0.0

 

4、brew services stop mysql

 

brew services start mysql