1、修改root密码
用SET PASSWORD命令
mysql -u root
SET PASSWORD FOR 'root'@'localhost' = PASSWORD('newpass');
2、允许外网访问
进入MYSQL
mysql -uroot -p
use mysql;
update user set host='%' where user='root' and host='localhost';
输入以上命令后执行重启MYSQL,并且刷新MySQL的系统权限相关表
sudo service mysql restart
flush privileges