连接mysqlworkbench出现如下提示:
![](https://images0.cnblogs.com/blog2015/781735/201508/052218575958491.png)
查看ip
![](https://images0.cnblogs.com/blog2015/781735/201508/052219525808793.png)
加入host的范围
mysql> select user,host from mysql.user;
+-------------+---------------+
| user | host |
+-------------+---------------+
| root | 127.0.0.1 |
| zejin | 192.168.%.% |
+-------------+---------------+
| user | host |
+-------------+---------------+
| root | 127.0.0.1 |
| zejin | 192.168.%.% |
还是连接不上
mysql> flush privileges;
Query OK, 0 rows affected (0.04 sec)
Query OK, 0 rows affected (0.04 sec)
![](https://images0.cnblogs.com/blog2015/781735/201508/052220028307528.png)
终于成功。记得权限类的要flush privileges!