Sorry for bothering you so much. But I have a lot of issues and can’t solve.
I am deploying openstack with openstack base charm.
I met a lot of error on units. Almost It caused by Mysql Router not yet bootstrapped. When I ssh into lxd , it showed me error
2020-06-09 20:17:15 ERROR juju-log Failed to bootstrap mysqlrouter: Error: Unable to connect to the metadata server: Error connecting to MySQL server at 192.168.28.25:0: Access denied for user ‘mysqlrouteruser’@‘192.168.28.11’ (using password: YES) (1045)
This is my juju status: Ubuntu Pastebin
I searched and it looks like a old bug : Bug #1861234 “The documented miniumum grants for bootstrap are i...” : Bugs : charm-mysql-router . It have a workaround like add a GRANT to mysql_innodb_cluster_metadata
But I have no password + username to login into Innodb Cluster .
Please have a look and help me how to troubleshoot this case.