# sudo /usr/bin/mysqlrouter --user mysql --name keystone-mysql-router --bootstrap mysqlrouteruser:<PASSWORD>@252.153.13.224 --directory /var/lib/mysql/keystone-mysql-router --conf-use-sockets --conf-bind-address 127.0.0.1 --report-host 252.153.11.1 --conf-base-port 3306 --disable-rest --force
Error: Unable to connect to the metadata server: Error connecting to MySQL server at 252.153.13.224:0: Access denied for user 'mysqlrouteruser'@'252.153.11.1' (using password: YES) (1045)
Seems mysql cluster is not accepting clients coming from different subnets.
If I replace --report-host by its FAN IP, I get:
# sudo /usr/bin/ mysqlrouter --user mysql --name keystone- mysql-router --bootstrap mysqlrouteruser :<PASSWORD> @252.153. 13.224 --directory /var/lib/ mysql/keystone- mysql-router --conf-use-sockets --conf-bind-address 127.0.0.1 --report-host 252.153.11.1 --conf-base-port 3306 --disable-rest --force r'@'252. 153.11. 1' (using password: YES) (1045)
Error: Unable to connect to the metadata server: Error connecting to MySQL server at 252.153.13.224:0: Access denied for user 'mysqlrouteruse
Seems mysql cluster is not accepting clients coming from different subnets.