ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
来源:互联网 发布:网络购物合同纠纷举证 编辑:程序博客网 时间:2024/05/24 01:28
想着在虚机上访问本地(windows)的数据库,在虚机上装好mysql后(apt-get install mysql)想着用命令mysql -h192.168.225.1 -uroot -P3306 campus去访问本地的数据库结果提示
ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
解决方法:
在本地的客户端中执行命令:
grant all PRIVILEGES on campus.* to root@'192.168.225.128' identified by '123456';(这样相当于给128这台服务器开通了访问权限)
在linux中执行命令mysql -h192.168.225.1 -uroot -p'123456' -P3306 campus即可
期间遇到的问题:
在vi编辑其中,按上下左右四个箭头的时候会出现A,B,C,D四个字母,而并不是响应移动
解决方法:
安装vim(apt-get install vim)
0 0
- ERROR 1130 (HY000): Host '192.168.225.128' 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
- 解决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 '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远程连接: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解决办法
- IT忍者神龟之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解决办法
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
- SQLSTATE[HY000] [1130] Host 'DESKTOP-O0CRH8F' is not allowed to connect to this MySQL server
- 面试求职之准备篇
- linux常用命令整理之五
- Codeforces534C:Polycarpus' Dice
- 斐波那契数列的几种计算机解法
- linux常用命令整理之六
- ERROR 1130 (HY000): Host '192.168.225.128' is not allowed to connect to this MySQL server
- 字符串压缩
- swift app入门 学习总结
- linux常用命令整理之七
- HTML5 SVG 特效示例
- CSU 1562 — Fun House
- Codeforces534D:Handshakes
- utf-8 unicode 各种编码的区别与联系
- 进程间通信简单实现之SendMessage/PostMessage