Issue with privileges

[LukasAud]

Describe the Bug

There is an issue with idempotency checks in privilege granting test cases. Further description available at:
#1466
This issue might be related to the behaviour of newer versions of mysql regarding dynamic privileges (which are the ones that seem to be duplicated).

Expected Behavior

The test run should pass green and not require several codes of block to avoid wrong privilege retrieval.

Steps to Reproduce

1. Remove lines 70 - 87 of code in /lib/puppet/provider/mysql_grant/mysql.rb
2. Run acceptance tests

Environment

• Mysql module version 12.0.2

Additional Context

The workaround fix for this issue was implemented at:
#1466
and
#1472