Bug #98575 Update docs to reflect need for EXECUTE priv. for latest router
Submitted: 13 Feb 2020 8:23 Modified: 21 May 2020 22:26
Reporter: Nir Gilboa Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Router Documentation Severity:S3 (Non-critical)
Version:8.0.19 OS:Any
Assigned to: CPU Architecture:Any

[13 Feb 2020 8:23] Nir Gilboa
Description:
Setting up MySQL Router 8.0.19 to access an InnoDB Cluster 8.0.19 requires an additional privilege as of the latest version, which is not documented.

Documentation:
https://dev.mysql.com/doc/mysql-router/8.0/en/mysqlrouter.html

Missing EXECUTE in the following:
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql_innodb_cluster_metadata.* TO
'bootstrapuser'@'%';

Additional details:
https://bugs.launchpad.net/charm-mysql-router/+bug/1861234

How to repeat:
1. Set up a 8.0.19 cluster
2. Attempt to bring up a 8.0.19 using the current documentation. You'll run into an error bootstrapping the router - specifically failure to create an account.

Suggested fix:
Update the documentation accordingly - add the EXECUTE privilege.
[24 Feb 2020 6:28] MySQL Verification Team
Hello Nir Gilboa,

Thank you for the report and feedback.

regards,
Umesh
[21 May 2020 22:26] Philip Olson
Posted by developer:
 
Thank you Gilboa for the bug report, this bug is fixed in the documentation.