开启与关闭数据库的远程连接

开启

打开命令窗口

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;