mysql -u root -p123456
use mysql
selectuser,host fromuser;updateuserset host ='%'whereuser='root';selectuser,host fromuser;grantallprivilegeson*.*to'root'@'%'withgrantoption;
flush privileges;
mysql支持ip访问mysql支持ip访问命令截图mysql支持ip访问命令mysql -u root -p123456use mysqlselect user,host from user; update user set host = '%' where user = 'root';select user,host from user; grant all privileges on *.* to 'root'@'%' with grant option;flush privileg