Navicat 连接localhost失败
Navicat 不联网的情况下,主机名localhost就相当于一个字符串,是解析不到本地主机。
需要改用本地ip地址
错误
host '190.111.11.11' is not allowed to connect to this mysql server
需要,更改MySQL权限,
首先登录MySQL
用cmd进入MySQL安装目录bin下
登录MySQL
mysql -uroot -p123
mysql> use mysql
mysql> select host ,user ,password from user;
查看user表,只能通过localhost访问。
修改权限
mysql> use mysql;
mysql> grant all privileges on portal.* to root@zq27 identified by 'root';
mysql> update user set host = '%' where user = 'root';
mysql> select host, user from user;
mysql> flush privileges;
mysql>grant all privileges on *.* to 'root'@'%' identified by 'root';
*.*表示所有数据库的所有表
%:所有IP