MySQL安装好后,预设只能用localhost来访问,
用IP直接连接MySQL Server,报Error 1130,如图,解决办法如下:
解决办法:
# mysql
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;
mysql> exit
MySQL安装好后,预设只能用localhost来访问,
用IP直接连接MySQL Server,报Error 1130,如图,解决办法如下:
解决办法:
# mysql
mysql> grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql> flush privileges;
mysql> exit