Comment 19 for bug 1967177

This is affecting us as well... I can see clearly in the juju logs on the unit that it fails to connect:

2024-02-29 00:27:01 ERROR unit.placement-mysql-router/5.juju-log server.go:316 db-router:70: Failed to bootstrap mysqlrouter: Error: Unable to connect to the metadata server: Error connecting to MySQL server at 10.100.33.27:0: Access denied for user 'mysqlrouteruser'@'10.100.33.2' (using password: YES) (1045)

But looking in the database... the grants look right. At the end of all of this we even see an established connection to the RW member of the DB cluster.

But... it's clearly not progressing beyond the bootstrap:
[metadata_cache:bootstrap]
cluster_type = gr
router_id = 35
user = mysql_router35_jboetej22v83
metadata_cluster = jujuCluster
ttl = 0.5
auth_cache_ttl = -1
auth_cache_refresh_interval = 2
use_gr_notifications = 0

[routing:bootstrap_rw]
bind_address = 127.0.0.1
bind_port = 3306
socket = /var/lib/mysql/placement-mysql-router/mysql.sock
destinations = metadata-cache://jujuCluster/?role=PRIMARY
routing_strategy = first-available
protocol = classic

[routing:bootstrap_ro]
bind_address = 127.0.0.1
bind_port = 3307
socket = /var/lib/mysql/placement-mysql-router/mysqlro.sock
destinations = metadata-cache://jujuCluster/?role=SECONDARY
routing_strategy = round-robin-with-fallback
protocol = classic

[routing:bootstrap_x_rw]
bind_address = 127.0.0.1
bind_port = 3308
socket = /var/lib/mysql/placement-mysql-router/mysqlx.sock
destinations = metadata-cache://jujuCluster/?role=PRIMARY
routing_strategy = first-available
protocol = x

[routing:bootstrap_x_ro]
bind_address = 127.0.0.1
bind_port = 3309
socket = /var/lib/mysql/placement-mysql-router/mysqlxro.sock
destinations = metadata-cache://jujuCluster/?role=SECONDARY
routing_strategy = round-robin-with-fallback
protocol = x