【中间件mycat服务器能登上从库mysql服务器，但是连不上主库mysql】

问题：

主从库mysql服务器同步完成，并创建完成mycatuser授权完成后，在mycat服务器尝试登录mycatuse，远程主库登录报错，远程从库可以登上

1. 环境

serverA：主库ip 192.168.1.100
serverB：从库ip 192.168.1.132
mycat：中间件ip 192.168.1.133

2. 后端数据库建立的允许mycat连接的用户

mysql> CREATE USER 'mycatuser'@"192.168.1.133" IDENTIFIED BY 'WWW.1.com';
Query OK, 0 rows affected (0.00 sec)

mysql> GRANT all ON game.* TO 'mycatuser'@"192.168.140.12";
Query OK, 0 rows affected (0.00 sec)

mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

3. 远程登录主库

[root@client conf]# mysql -umycatuser -pWWW.1.com -h192.168.100
mysql: [Warning] Using a password on the command line interface can be insecure.
ERROR 2003 (HY000): Can't connect to MySQL server on '192.168.1.131' (113)

4. 远程登录从库

[root@client conf]# mysql -umycatuser -pWWW.1.com -h192.168.1.132
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 21
Server version: 8.0.12 MySQL Community Server - GPL

Copyright (c) 2000, 2018, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> 
mysql> 

解决：

。。。ip输错了

[root@client conf]# /usr/local/mycat/bin/mycat restart 
Stopping Mycat-server...
Stopped Mycat-server.
Starting Mycat-server...
[root@client conf]# netstat -tunlp | grep java 
tcp        0      0 127.0.0.1:32000         0.0.0.0:*               LISTEN      2133/java           
tcp6       0      0 :::45119                :::*                    LISTEN      2133/java           
tcp6       0      0 :::1984                 :::*                    LISTEN      2133/java           
tcp6       0      0 :::8066                 :::*                    LISTEN      2133/java           
tcp6       0      0 :::33929                :::*                    LISTEN      2133/java           
tcp6       0      0 :::9066                 :::*                    LISTEN      2133/java           
[root@client conf]#