允许Mysql远程连接

• 登录数据库

mysql -uroot -p

• use一下mysql库

use mysql;

-如果没有设置密码,设置一下密码

use mysql;
update user set authentication_string=PASSWORD("要设置的密码") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;
#mysql5.7.9之后要用这个
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';

• 设置所有电脑都能远程(%)或者指定电脑

update user set host='%' where user='root' and host='localhost';

• 一定要刷新配置

flush privileges;