mysql本地访问linux服务器,出现SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this
来源:互联网 发布:澳洲gpa算法 编辑:程序博客网 时间:2024/05/18 03:38
解决方案:网上看了说,更改mysql库的user表,添加一条host为%的数据就可以,但是还是不行。后来,直接登录mysql,给访问加权限就可以了。
执行
[root@iZ25p77kem7Z ~]# GRANT ALL PRIVILEGES ON *.* TO 'username'@'%' IDENTIFIED BY 'userpwd' WITH GRANT OPTION;
就可以了
0 0
- mysql本地访问linux服务器,出现SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this
- SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this MySQL server怎么解决?
- 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 的解决办法
- 解决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 'localhost' is not allowed to connect to this MySQL解决方式
- ERROR 1130 (HY000): Host 'xxx' is not allowed to connect to this MySQL server
- 腾讯云安装配置Apache+MariaDB服务器并解决SQLSTATE[HY000] [1130] Host t '*’ is not allowed to connect to this se问题
- DevExpress XPO 数据库 连接与展示
- 黑马程序员——22,字节流InputStream,OutputStream,字节流缓冲区技术,BufferedInputStream,BufferedOutputStream
- Tcl学习之-- 错误|异常
- UVA232 纵横字的解答
- 数据结构—二分查找
- mysql本地访问linux服务器,出现SQLSTATE[HY000] [1130] Host '127.0.0.1' is not allowed to connect to this
- 贾青深夜前往派出所报案严厉谴责不雅照事件
- C++学习
- 散列表的C语言实现-开放定址法
- 《爵迹》主演海报集合票房被看好郭敬明颜控造福粉丝
- 九度oj 1131
- CasperJS 抓取京东商品详情页中的商品信息
- 【shell脚本练习】grep sed awk
- CodeForces 435B