Support dynamic grants in MySQL8

petoju / terraform-provider-mysql

Terraform MySQL provider – unofficial fork

Mozilla Public License 2.0

63 stars 40 forks source link

Closed petoju closed 10 months ago

petoju commented 10 months ago

It seems dynamic grants in MySQL8 don't obey the original grant model, where SHOW GRANTS shows them in 1 row.

Instead, there are 2 rows - one for static grants like SELECT and one for dynamic grants.

I added test and started merging all grants to make sure we get everything here.

As the new test works now (and didn't work before), I am reasonably convinced this works.

bigwheel commented 10 months ago

@petoju Few weeks ago, we encountered this problem after upgrade mysql 8.0. So happy because you fixed this <3