yandex_mdb_mysql_user (Data Source)
Статья создана
Обновлена 17 ноября 2025 г.
Get information about a Yandex Managed MySQL user. For more information, see the official documentation.
Example usage
//
// Get information about existing MDB MySQL Database User.
//
data "yandex_mdb_mysql_user" "my_user" {
cluster_id = "some_cluster_id"
name = "test"
}
output "permission" {
value = data.yandex_mdb_mysql_user.foo.permission
}
Schema
Required
cluster_id(String) The ID of the MySQL cluster.name(String) The name of the MySQL user.
Optional
permission(Block Set) (see below for nested schema)
Read-Only
authentication_plugin(String) Authentication plugin. Allowed values:MYSQL_NATIVE_PASSWORD,CACHING_SHA2_PASSWORD,SHA256_PASSWORD,MYSQL_NO_LOGIN,MDB_IAMPROXY_AUTH(for version 5.7MYSQL_NATIVE_PASSWORD,SHA256_PASSWORD,MYSQL_NO_LOGIN,MDB_IAMPROXY_AUTH).connection_limits(List of Object) (see below for nested schema)connection_manager(Map of String) Connection Manager connection configuration. Filled in by the server automatically.global_permissions(Set of String) List user's global permissions. Allowed permissions:REPLICATION_CLIENT,REPLICATION_SLAVE,PROCESS,FLUSH_OPTIMIZER_COSTS,SHOW_ROUTINE,MDB_ADMINfor clear list use empty list. If the attribute is not specified there will be no changes.id(String) The ID of this resource.
Nested Schema for permission
Optional:
roles(List of String) List user's roles in the database. Allowed roles:ALL,ALTER,ALTER_ROUTINE,CREATE,CREATE_ROUTINE,CREATE_TEMPORARY_TABLES,CREATE_VIEW,DELETE,DROP,EVENT,EXECUTE,INDEX,INSERT,LOCK_TABLES,SELECT,SHOW_VIEW,TRIGGER,UPDATE,REFERENCES.
Read-Only:
database_name(String) The name of the database that the permission grants access to.
Nested Schema for connection_limits
Read-Only:
-
max_connections_per_hour(Number) Max connections per hour. -
max_questions_per_hour(Number) Max questions per hour. -
max_updates_per_hour(Number) Max updates per hour. -
max_user_connections(Number) Max user connections.