Rechercher dans le manuel MySQL
13.7.1 Account Management Statements
[+/-]
MySQL account information is stored in the tables of the
mysql
system database. This database and the
access control system are discussed extensively in
Chapter 5, MySQL Server Administration, which you should consult
for additional details.
Some MySQL releases introduce changes to the grant tables to add new privileges or features. To make sure that you can take advantage of any new capabilities, update your grant tables to the current structure whenever you upgrade MySQL. See Section 2.11, “Upgrading MySQL”.
When the read_only
system
variable is enabled, account-management statements require the
CONNECTION_ADMIN
or
SUPER
privilege, in addition to any
other required privileges. This is because they modify tables in
the mysql
system database.
Account management statements are atomic and crash safe. For more information, see Section 13.1.1, “Atomic Data Definition Statement Support”.
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-account-management-sql.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.