provider "mysql" { 
  endpoint = "localhost:3306" 
  username = "root" 
  password = "" 
} 

resource "mysql_database" "test" { 
  name = "test" 
} 

resource "mysql_role" "developer" { 
  name = "developer" 
} 

resource "mysql_grant" "developer_priviliges" { 
  role       = mysql_role.developer.name
  database   = "test" 
  privileges = ["SELECT", "INSERT", "UPDATE", "DELETE"] 
} 

resource "mysql_grant" "user_to_roles" { 
  database = "test" 
  user     = "foo"
  host     = "%"
  roles    = [mysql_role.developer.name] 
}