search

puppetlabs / puppetlabs-mysql

MySQL Puppet Module / Manifests + Types & Providers
Apache License 2.0
380 stars 796 forks source link

add another workaround for mysql_grant provider for mysql >= 8.0.27 #1542

Closed david-barbion closed 1 year ago

david-barbion commented 1 year ago

Starting MySQL 8.0.27, a new privilege is added: FIREWALL_EXEMPT. When granting ALL PRIVILEGES, this new privilege is also granted.

This PR adds a new workaround for this use case.

Ref: https://dev.mysql.com/doc/refman/8.0/en/privileges-provided.html#priv_firewall-exempt

CLAassistant commented 1 year ago

CLA assistant check
All committers have signed the CLA.

david-barbion commented 1 year ago

This may also address issue #1502

david-barbion commented 1 year ago

FIREWALL_EXEMPT is a Mysql enterprise plugin permission that should not be available in the community edition. Closing this PR as it won't help in the globalization of the handling of permissions...