ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
来源:互联网 发布:淘宝旗袍模特 周婷 编辑:程序博客网 时间:2024/05/18 17:41
先停止mysql 服务 doc命令: net stop mysql
然后重启mysql服务 net start mysql
mysql -u root -p
出现Enter password: 直接按回车键 提示welcome to the MySQL
然后 use mysql
提示 Datebase changed
输入语句 update user set host='%' where user='root';
提示 query OK,
然后 flush privileges
select host,use from user;
最后QUIT
虽然不知道host=‘%’ 是什么意思 但是好用了
阅读全文
0 0
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
- 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 'localhost' 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 '192.168.1.9' is not allowed to connect to this MySQL server
- IT忍者神龟之mysql远程连接:ERROR 1130 (HY000): Host '*.*.*.*' 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 '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 'xxx' is not allowed to connect to this MySQL server
- [MySQL]MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MySQL Error 1130 Host 'localhost' is not allowed to connect to this MySQL server
- MFC中在界面上添加背景图片的方法
- Nginx配置文件详细说明
- 修改maven打包名字
- Android:用GSON 五招之内搞定任何JSON数组
- JSP 添加cookie、获取cookie
- ERROR 1130 (HY000): Host 'localhost' is not allowed to connect to this MySQL解决方式
- 基于 webpack 搭建前端工程基础篇
- android 动态权限请求(整理自官方指南)
- 单例能被反射吗?肯定能。
- POJ 1986 Distance Queries && HDOJ 2586 How far away?
- linux服务器性能——CPU、内存、流量、磁盘使用率的监控
- Java 请求https接口不需要安装证书
- 如何在PHP7中安装mysql的扩展
- PHP的页面静态化简介。