Mysql8.0数据库远程管理

开启MySQL服务

net start mysql80

关闭MySQL服务

net stop mysql80

更改为远程连接

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

更改为本地连接

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

授权 root 用户的所有权限并设置远程访问

GRANT ALL ON *.* TO 'root'@'%';

刷新权限

flush privileges;

查看用户和密码

select user,password,host from user;

删除用户

delete from mysql.user where user='' and host='';

修改密码

update mysql.user set password=PASSWORD('111111') where user='root';

修改加密规则

ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;