32.3.3 配置ProxySQL读写分离
1.创建MySQL用户
在binghe151服务器的主库上创建ProxySQL连接MySQL的用户信息和监控MySQL的用户信息。
mysql> CREATE USER 'proxysql'@'192.168.175.153' IDENTIFIED BY 'proxysql123456';
Query OK, 0 rows affected (0.00 sec)
mysql> ALTER USER 'proxysql'@'192.168.175.153' IDENTIFIED WITH mysql_native_password BY 'proxysql123456';
Query OK, 0 rows affected (0.00 sec)
mysql> GRANT ALL ON *.* TO 'proxysql'@'192.168.175.153';
Query OK, 0 rows affected (0.00 sec)
mysql> CREATE USER 'monitor'@'%' IDENTIFIED BY 'monitor123456';
Query OK, 0 rows affected (0.10 sec)
mysql> ALTER USER 'monitor'@'%' IDENTIFIED WITH mysql_native_password BY 'monitor123456';
Query OK, 0 rows