Feature: Import users from database

[RTodorov]

Hi there,

Currently, mysql_user resource can't be imported via terraform import. Is there any reason why this is not possible or do we simply need to implement it? In case it's all about implementation, I can give it a try.

Thank you

[morganchristiansson]

There is open PR #113

[dcposch]

that PR was closed yesterday.

this issue is making terraform-provider-mysql very difficult to use in production. there is no good way to bring the Terraform state into sync with the MySQL server state.

related: it would be very useful to be able to tell terraform to ensure that a server contains only the MySQL users defined in terraform.

as it stands, we are running servers that:

• have a few users created by terraform-provider-mysql
• have additional, pre-existing users that are not in terraform
• i cannot add them due to the missing import capability (this issue)
• terraform does not flag the existence of those extraneous users as a diff, either.

that negates most of the value of having the MySQL auth in terraform.