如果在本博客下载附件后需要解压密码,请尝试本站域名作为解密密码:www.skyfinder.cc

 分类:MySql

Host is not allowed to connect to this MySQL server问题

在应用部署后访问中出现一下错误: ERROR 1130: Host ‘localhost’ is not allowed to connect to this MySQL server 其实就是 MySQL 不允许当前的Host进行连接。为了本地以后测试方便,暴力解决方法如下: 1.在装有MySQL的机器上登录MySQL:mysql -uroot -p密码2.选择我mysql库,执行use mysql;3.更新user表,执行update user set host = ‘%’ where user = ‘root’;这一句执行完可能会报错,不用管它。4.执行FLUSH PRIVILEGES; 转载请注明:清风博客 » Host is not allowed ...

6个月前 (09-06) 78℃ 0评论 0喜欢