ull, message from server: "Host '112.111.61.200' is not allowed to connect to this MySQL server"
2023-09-11 14:22:42 时间
我是迁移项目后,项目访问数据库时报的这个异常。这个异常是数据库只允许localhost或127.0.0.1访问,不允许远程访问。我用的本机IP都不行。
解决办法:修改访问权限即可。
打开cmd,进入mysql
flush privileges是为了将权限更新操作刷新到内存中,而不用下次启动时生效。
当然也可以直接选择重启mysql的方式:
参考:https://blog.csdn.net/xionglangs/article/details/50385057
————————————————
版权声明:本文为CSDN博主「杨不休」的原创文章,遵循CC 4.0 BY-SA版权协议,转载请附上原文出处链接及本声明。
原文链接:https://blog.csdn.net/m0_37460012/article/details/90290148
相关文章
- Procedure execution failed 2013 - Lost connection to MySQL server during query
- Host 'XXX' is not allowed to connect to this MySQL server 解决方案/如何开启MySQL的远程帐号
- mysql启动时报错:Starting MySQL... ERROR! The server quit without updating PID file (/opt/mysql/data/mysql.pid) 的解决方法
- Mysql连接错误:Lost connection to Mysql server at 'waiting for initial communication packet'
- mysql错误:java.sql.SQLException: The server time zone value ‘xxx‘ is unrecognized or represents 解决方法
- SQL SERVER错误:已超过了锁请求超时时段。 (Microsoft SQL Server,错误: 1222)
- Mysql错误check the manual that corresponds to your MySQL server version for the right syntax
- mysql 几阶b树_在学到MySQL索引时,涉及到了B树和B+树.聊一聊
- MySQL mysqldump备份数据库及恢复数据库(mysql命令)
- cant connect to mysql server on
- sqlyog Can't connect to MySQL server on localhost (0)
- Can't connect to local MySQL server through socket
- mysql更新字段值提示You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column To disable safe mode
- 使用navicat连接mysql连接错误:Lost connection to Mysql server at 'waiting for initial communication packet'
- python操作mysql数据库系列-操作MySql数据库(一)
- Ubuntu Server无桌面无显示器情况下虚拟屏幕xvfb的安装及设置—ubuntu18.04server服务器系统下为python安装虚拟显示器 (使用jupyter notebook在web端播放openai的gym下保存的运行视频——需安装ipython)
- MySQL连接失败:10061错误,Can't connect to MySQL server on '127.0.0.1' (10061) (2003)
- mysql 分组统计、排序、取前N条记录解决方案
- ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var mysql (转)
- message from server: “Host is not allowed to connect to this MySQL server“解决办法
- sql server链接mysql
- (5.5)mysql高可用系列——MySQL半同步复制(实践)
- is not allowed to connect to this MySql server
- Mysql启动失败,报Can‘t start server: can‘t create PID file: No such file or directory解决方案
- mysql:1130 is not allowed to connect to this MariaDB server解决办法
- IDE连接MySQL报错:Server returns invalid timezone. Go to ‘Advanced‘ tab and set ‘serverTimezone‘ property