MySQL InnoDB集群如何更改内部Router用户的密码？
如何更改MySQL路由器用来与集群节点通信的内部路由器用户密码？
1、要在MySQL级别更改密码，请在集群的主节点上使用以下命令:
(Mon Sep 11 11:16:11 2023)[root@GreatSQL][(none)]>select hex(authentication_string) from mysql.user where user ='mysql_router1_csrx95gqhf7g';
+------------------------------------------------------------------------------------+
| hex(authentication_string) |
+------------------------------------------------------------------------------------+
| 2A32323230413845303734304231454542453638333141423432344134383434353433334441373842 |
+------------------------------------------------------------------------------------+
1 row in set (0.01 sec)
(Mon Sep 11 11:17:34 2023)[root@GreatSQL][(none)]>SET PASSWORD FOR mysql_router1_csrx95gqhf7g@'%' ='haisDFFef#fgs123';
Query OK, 0 rows affected (0.00 sec)
(Mon Sep 11 11:22:44 2023)[root@GreatSQL][(none)]>select hex(authentication_string) from mysql.user where user ='mysql_router1_csrx95gqhf7g';
+------------------------------------------------------------------------------------+
| hex(authentication_string) |
+------------------------------------------------------------------------------------+
| 2A35464544453241394230433331414644443946434430353936454546353841303437303745343934 |
+------------------------------------------------------------------------------------+
1 row in set (0.00 sec)
