SQLSTATE[HY000] [1130] Host 'DESKTOP-O0CRH8F' is not allowed to connect to this MySQL server
来源:互联网 发布:科蒂斯电动牙刷 知乎 编辑:程序博客网 时间:2024/06/06 00:38
1.发生这种情况是由于没有MySQL没有赋予权限;
2.打开MySQL 5.7 Command Line Client,输入密码进入;
3.输入以下命令(大小写都可以):
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '123456' WITH GRANT OPTION;
mysql>flush privileges;
mysql>exit;
阅读全文
1 0
- SQLSTATE[HY000] [1130] Host 'DESKTOP-O0CRH8F' is not allowed to connect to this MySQL server
- SQLSTATE[HY000] [1130] Host '139.129.142.19' is not allowed to connect to this MySQL server 的解决办法
- SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this MySQL server怎么解决?
- 解决MySQL ERROR 1130 (HY000): Host 'XXX' is not allowed to connect to this MySQL server
- 解决MySQL ERROR 1130 (HY000): Host 'XXXX' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'xxxxxx' is not allowed to connect to this MySQL server解决办法
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- 解决ERROR 1130 (HY000): Host '192.168.1.9' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '10.117.1.13' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '172.16.0.123' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host '113.57.150.82' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL server
- ERROR 1130 (HY000): Host 'xxx' is not allowed to connect to this MySQL server
- mysql本地访问linux服务器,出现SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' is not allowed to connect to this MySQL server解决办法
- [ HDUOJ 6081 ] 度度熊的王国战略 [并查集]
- Android Uri
- hadoop之wordcount
- html5之Range对象详解
- c#获取本地连接的ip 子网掩码 网关 DNS
- SQLSTATE[HY000] [1130] Host 'DESKTOP-O0CRH8F' is not allowed to connect to this MySQL server
- qduoj kkun的一道简单签到题(优先队列)
- JSP课设(课程设计选题管理系统)
- html2canvas完整demo解决图片跨域问题(已经成功啦啦)
- wangeditor2版本如何本地上传图片
- RecyclerView瀑布流的形式利用Gilde加载网络图片
- 多标签图像分类任务的评价方法-mAP
- Javascript第一天学习总结
- SQL DATEADD() 函数