Bureaucrats, editor, reviewer, Administrators
13,554
edits
Changes
Jump to navigation
Jump to search
→User Management
=User Management=
Updated with {{Version|8.0}}: all passwords are now specified in plain text (see [[User Management]] for more information).
==CREATE USER==
{| width='100%'
|-
|-
| '''Summary'''
|Creates a user with the specified {{Code|[name]}} and {{Code|[password]}}. {{Code|[name]}} must be a [[#Valid Names|valid user name]]. The password must be a valid MD5 hash value. If no password is specified in the console mode, it is requested via standard inputthe chosen frontend (GUI or bash).
|-
| '''Errors'''
|-
| '''Summary'''
|Alters the {{Code|[password]}} of the user with the specified {{Code|[name]}}. The password is specified in plain text. If no password is specified, it is requested via the chosen frontend (GUI or bash).
|-
| '''Errors'''
|-
| '''Summary'''
|Drops the user with the specified {{Code|[name]}}. The [[#Glob Syntax|Glob Syntax]] can be used to address more than one database or user. If a glob {{Code|[pattern]}} is specified, only the pattern will be removed.
|-
| '''Errors'''
|The command fails if {{Code|admin}} is specified as user name, or if the specified user does not exist or is currently logged in.
|}
|-
| '''Summary'''
|Grants the specified [[User_Management|permission]] to the specified {{Code|[user]}}. The [[#Glob Syntax|Glob Syntax]] can be used to address more than one user. If a glob {{Code|[pattern]}} is specified, the permission will be applied to all databases that match this pattern.
|-
| '''Errors'''
==PASSWORD==
{| width='100%'
|-
|-
| '''Summary'''
|Changes the {{Code|[password]}} of the current user. The password must be a valid MD5 hash value. If no password is specified in the console mode, it is requested via standard input.|-| '''Errors'''|The command fails if the password is no valid MD5 hash valuechosen frontend (GUI or bash).
|}
