开启
打开命令窗口
cmd
1登录数据库
mysql -uroot -p
2连接mysql数据库
user mysql
3赋权给root用户,所有ip都能连接,连接时密码是123456
GRANT ALL PRIVILEGES ON . TO ‘root’@’%'IDENTIFIED BY ‘123456’ WITH GRANT OPTION;
4权限刷新
flush privileges;
关闭
1权限回收
REVOKE ALL PRIVILEGES ON . from ‘root’@’%’;
2root用户禁止远程连接
DELETE FROM user WHERE User= “root” and Host="%";
3权限刷新
flush privileges;