The documented miniumum grants for bootstrap are insufficient

[David Ames]

The documented [0] minimum grants for bootstrap are insufficient

GRANT CREATE USER ON *.* TO 'bootstrapuser'@'%' WITH GRANT OPTION;
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql_innodb_cluster_metadata.* TO 'bootstrapuser'@'%';
GRANT SELECT ON mysql.user TO 'bootstrapuser'@'%';
GRANT SELECT ON performance_schema.replication_group_members TO 'bootstrapuser'@'%';
GRANT SELECT ON performance_schema.replication_group_member_stats TO 'bootstrapuser'@'%';

Leads to the following error during bootstrap:

# Bootstrapping MySQL Router instance at '/var/lib/mysql/mysqlrouter'...

- Creating account(s) (only those that are needed, if any)
Error: Error creating MySQL account for router (GRANTs stage): Error executing MySQL query "GRANT SELECT, EXECUTE ON mysql_innodb_cluster_metadata.* TO 'mysql_router1_q6s4xhiu9ija'@'%'": Access denied for user 'bootstrapuser'@'10.5.0.18' to database 'mysql_innodb_cluster_metadata' (1044)

Since 8.0.19. This worked with 8.0.18.

[0] https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html#option_mysqlrouter_bootstrap

TRIAGE: Determine the missing grants

[David Ames (thedac)]

The missing grant is EXECUTE on mysql_innodb_cluster_metadata

The line should be:
GRANT SELECT, INSERT, UPDATE, DELETE, EXECUTE ON mysql_innodb_cluster_metadata.* TO 'mysqlrouteruser'@'10.5.0.23';

This is updated in charm helpers.

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/704715

[David Ames (thedac)]

Charm helpers PR: https://github.com/juju/charm-helpers/pull/424

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/704715
Committed: https://git.openstack.org/cgit/openstack/charm-mysql-innodb-cluster/commit/?id=40e41ad1528880937402014dd099ad5fe31d2f9d
Submitter: Zuul
Branch: master

commit 40e41ad1528880937402014dd099ad5fe31d2f9d
Author: David Ames <email address hidden>
Date: Tue Jan 28 16:15:19 2020 -0800

    Rebuild and cleanup

    Rebiuld for charmhelpers.
    Remove wheelhouse overrides in tox.

    Please review and land charm-helpers:
    https://github.com/juju/charm-helpers/pull/424

    Change-Id: I7faf3abc19564d715adb99ea0962c013751cef04
    Partial-Bug: #1861234