mysql 8.0禁止远程连接_MySQL8.0设置远程访问权限(解决Navicat无法远程连接)

版权声明：本文为博主原创文章，未经博主允许不得转载。 https://blog.youkuaiyun.com/MYians/article/details/90751027

MySQL8.0设置远程访问权限(解决Navicat无法远程连接)

如果是Windows系统的Mysql允许局域网其他用户访问,请先配置文末的设置

1、连接Mysql(root):mysql -u root -p

2、输入密码：******

3、创建访客用户(需设置复杂密码 , 不建议使用简单密码)：CREATE USER ‘guest’@’%’ IDENTIFIED BY ‘Gusest123456.!’;

4、设置密码永不过期：ALTER USER ‘guest’@’%’ IDENTIFIED BY ‘Gusest123456.!’ PASSWORD EXPIRE NEVER;

5、修改加密规则：ALTER USER ‘guest’@’%’ IDENTIFIED WITH mysql_native_password BY ‘Gusest123456.!’;

6、授权访问某个数据库(指定 test 数据库)：GRANT ALL PRIVILEGES ON test.* TO ‘guest’@’%’ WITH GRANT OPTION;

7、刷新权限：FLUSH PRIVILEGES;

8、撤销权限(root)：REVOKE PRIVILEGES ON test.* FROM ‘guest’@’%’;

9、刷新权限：FLUSH PRIVILEGES;

10、删除用户(root)：DROP USER ‘guest’@’%’;

如果是Windows系统的Mysql允许局域网其他用户访问,请先配置以下设置࿱