Skip to content
This repository has been archived by the owner on Jan 12, 2021. It is now read-only.

Revoke grants issue in mysql provider version 1.5.0. Bad syntax #66

Open
ghost opened this issue Jan 18, 2019 · 0 comments
Open

Revoke grants issue in mysql provider version 1.5.0. Bad syntax #66

ghost opened this issue Jan 18, 2019 · 0 comments

Comments

@ghost
Copy link

ghost commented Jan 18, 2019

This issue was originally opened by @julio-id90 as hashicorp/terraform#20050. It was migrated here as a result of the provider split. The original body of the issue is below.


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!

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

0 participants