[linux] 外网连接mysql

mysql -hlocalhost -uroot -P3306 -p;
 
use mysql;
 
select * from user;
 
grant all privileges on *.* to 'root'@'%' identified by 'root' with grant option; flush 
 
flush privileges;