将mysql开放，使得能被外部连接

mysql -u root -p

use mysql
设置密码永远不会过期，记住这个时候还是只能本地连接，并不能外部连接，
ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
设置所有地址都可以访问mysql
update user set host='%' where user ='root';

update user set plugin='mysql_native_password' where user ='root';
授于所有权限
grant all on *.* to 'root'@'%';

flush privileges;

重启mysql