- 登录数据库
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;