Mycat搭建问题以及解决

配置好docker的mysql主从复制，此时要进入mycat时

[root@localhost local]# mysql -uroot -p123456 -h 192.168.66.100 -P 8066

报错

-bash: mysql: command not found

就是因为/usr/local/bin下mysql这个bin的命令缺失，想了下是由于主从mysql都在容器里面，宿主机当然没法通过mysql命令连接伪数据库，但是又不想搭个mysql。就复制一份到宿主机，执行命令

docker cp master:/bin/mysql /usr/local/bin

再连接一次

total 4104
-rwxr-xr-x. 1 root root 4200032 Aug 30 12:44 mysql
[root@localhost bin]# mysql -uroot -p123456 -h 192.168.66.100 -P 8066
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 1
Server version: 5.6.29-mycat-1.6.7.1-release-20190627191042 MyCat Server (OpenCloudDB)

Copyright (c) 2000, 2022, Oracle and/or its affiliates.

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> 

出现这个就可以了