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:
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
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.


Missing EXECUTE in the following:
GRANT SELECT, INSERT, UPDATE, DELETE ON mysql_innodb_cluster_metadata.* TO

Additional details:

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.

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