32.5.4 配置Mycat读写分离

32.5.4　配置Mycat读写分离

1．创建MySQL用户

在binghe151服务器的主库上创建Mycat连接MySQL的用户信息。

---

mysql> CREATE USER mycat@'192.168.175.153' IDENTIFIED BY 'mycat123456'; 
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'mycat'@'192.168.175.153' IDENTIFIED WITH mysql_native_password BY 'mycat123456'; 
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON *.* TO 'mycat'@'192.168.175.153';      
Query OK, 0 rows affected (0.00 sec)
mysql> FLUSH PRIVILEGES;
Query OK, 0 rows affected (0.00 sec)

---

2．查看Mycat配置文件

在binghe153服务器命令行输入如下命令查看Mycat安装目录下conf目录下的文件。

---

[root@binghe153 ~]# ll /usr/local/mycat/conf/
total 112
-rwxrwxrwx 1 root root   92 Oct 22 21:26 autopartiti