# User Management

MySQL and MariaDB / User Management

## Create MySQL user

 - [GET /Mysql/create_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/mysql-create_user.md): This function creates a MySQL® database user.

Important:

When you disable the MySQL role and remote MySQL is not already configured, the system disables this function.

## Delete MySQL user

 - [GET /Mysql/delete_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/mysql::delete_user.md): This function deletes a MySQL® user.

Important:

When you disable the MySQL role and remote MySQL is not already configured, the system disables this function.

## Return MySQL user privileges

 - [GET /Mysql/get_privileges_on_database](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/mysql-get_privileges_on_database.md): This function lists a MySQL® database user's privileges.

Important:

When you disable the MySQL role
and remote MySQL is not already configured, the system disables this function.

## Return MySQL name length restrictions

 - [GET /Mysql/get_restrictions](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/get_restrictions.md): This function lists a MySQL® database's name, username length restrictions, and database prefix.

Important:

  When you disable the MySQL/MariaDB role
  and remote MySQL is not already configured, the system disables this function.

## Return MySQL user routines

 - [GET /Mysql/list_routines](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/list_routines.md): This function returns a database user's MySQL® routines.

Important:

  When you disable the MySQL/MariaDB role and
  remote MySQL is not configured, the system disables this function.

## Return MySQL users

 - [GET /Mysql/list_users](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/mysql-list_users.md): This function lists an account's MySQL® database users.

Important:

  When you disable the MySQL/MariaDB role and
  remote MySQL is not configured, the system disables this function.

## Update MySQL username

 - [GET /Mysql/rename_user](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/rename_user.md): This function renames a MySQL® database user.

Important:

When you disable the MySQL role
 and remote MySQL is not already configured,
 the system disables this function.

## Remove MySQL user privileges

 - [GET /Mysql/revoke_access_to_database](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/revoke_access_to_database.md): This function revokes a MySQL® database user's privileges.

Important:

When you disable the MySQL role and
remote MySQL is not already configured, the system disables this function.

## Update MySQL user password

 - [GET /Mysql/set_password](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/mysql-set_password.md): This function sets a MySQL® database user's password.

Important:

When you disable the MySQL role
 and remote MySQL is not already configured,
 the system disables this function.

## Update MySQL user privileges

 - [GET /Mysql/set_privileges_on_database](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/set_privileges_on_database.md): This function sets a MySQL® database user's privileges.

Important:

When you disable the MySQL/MariaDB role, and remote MySQL is not already configured, the system disables this function.

## Update MySQL® privileges

 - [GET /Mysql/update_privileges](https://api.docs.cpanel.net/specifications/cpanel.openapi/user-management/update_privileges.md): This function updates privileges for all MySQL® databases and users on an account.

Important:

When you disable the MySQL/MariaDB role and
remote MySQL is not configured, the system disables this function.