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允许局域网其他用户访问,请先配置以下设置;
控制面板—>系统和安全—>Windows Defender 防火墙(win7/8/10可能不太一样)
—>高级设置—>入站规则(左侧面板)—&