Revoke grants issue in mysql provider version 1.5.0. Bad syntax

[julio-id90]

Hi people.
I've found an issue with the mysql provider version 1.5.0 which when trying to revoke grants misses the * after the database schema name:

mysql_grant.grant_new_subnet: error revoking GRANT (REVOKE GRANT OPTION ON `DB_NAME`. FROM 'user'@'172.16.1.0/255.255.255.0'): Error 1064: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'FROM 'user'@'172.16.1.0/255.255.255.0'' at line 1

It worked just fine with mysql provider's version 1.1.0

$ terraform -v
Terraform v0.11.9

Thanks!

[ghost]

This issue has been automatically migrated to hashicorp/terraform-provider-mysql#66 because it looks like an issue with that provider. If you believe this is not an issue with the provider, please reply to hashicorp/terraform-provider-mysql#66.

[ghost]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues.

If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.