PDF (US Ltr)
- 35.1Mb
PDF (A4)
- 35.2Mb
Man Pages (TGZ)
- 256.4Kb
Man Pages (Zip)
- 361.2Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/data-directory-initialization.html
Within the data directory, the server creates the mysql system database and its tables, including the grant tables, time zone tables, and server-side help tables. These include statements that relate to account management (such as CREATE USER or ...
https://dev.mysql.com/doc/refman/5.7/en/identifier-length.html
This applies to identifiers in table definitions that are stored in .frm files and to identifiers stored in the grant tables in the mysql database. The sizes of the identifier string columns in the grant tables are measured in characters. For ...
https://dev.mysql.com/doc/refman/5.7/en/password-logging.html
Passwords can be written as plain text in SQL statements such as CREATE USER, GRANT, SET PASSWORD, and statements that invoke the PASSWORD() function. (Direct modification of grant tables is discouraged, anyway.) For the general query log, password ...If such statements are logged by the MySQL server as written, passwords in them become visible to anyone with access to the ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-parameters.html
Changing the setting at runtime requires privileges sufficient to set global system variables. Configuration at runtime requires privileges sufficient to set global system variables (see Section 5.1.8.1, “System Variable Privileges”) and ...
https://dev.mysql.com/doc/refman/5.7/en/create-event.html
As granting such privileges entails a potential for abuse, extreme care must be taken in doing so. CREATE EVENT requires the EVENT privilege for the schema in which the event is to be created. If the DEFINER clause is present, the privileges ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-programs-ndb-restore.html
For more information, see Section 21.6.13, “Distributed Privileges Using Shared Grant Tables”. (In other words, you should start the data nodes with --initial prior to performing the restore.) --restore-privilege-tables Command-Line Format ...
https://dev.mysql.com/doc/refman/5.7/en/show-create-user.html
To display the privileges granted to an account, use the SHOW GRANTS statement. The statement requires the SELECT privilege for the mysql system database, except to display information for the current user. SHOW CREATE USER user This statement ...
https://dev.mysql.com/doc/refman/5.7/en/load-xml.html
To prevent a client from loading XML files from the server, do not grant the FILE privilege to the corresponding MySQL user account, or revoke this privilege if the client user account already has it. Important Revoking the FILE privilege (or not ...
https://dev.mysql.com/doc/refman/5.7/en/docker-mysql-more-topics.html
If a user name and a password are supplied with MYSQL_USER and MYSQL_PASSWORD, the user is created and granted superuser access to this database (corresponding to GRANT ALL). MYSQL_USER, MYSQL_PASSWORD: These variables are used in conjunction to ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-replication-preparation.html
Preparing the NDB Cluster for replication consists of the following steps: Check all MySQL servers for version compatibility (see Section 21.7.2, “General Requirements for NDB Cluster Replication”). To provide replication backup capability, you ...