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/server-status-variables.html
For more accurate memory usage calculations than with Innodb_buffer_pool_pages_data, when compressed tables cause the buffer pool to hold pages of different sizes. For more accurate memory usage calculations than with Innodb_buffer_pool_pages_dirty, ... The MySQL server maintains many status variables that provide information about its ...
https://dev.mysql.com/doc/refman/5.7/en/added-deprecated-removed.html
named_pipe_full_access_group: Name of Windows group granted full access to named pipe. Options and Variables Introduced in MySQL 5.7 Options and Variables Deprecated in MySQL 5.7 Options and Variables Removed in MySQL 5.7 This section lists server ...
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/default-privileges.html
The MySQL installation process involves initializing the data directory, including the grant tables in the mysql system database that define MySQL accounts. The mysql.user grant table defines the initial MySQL user account and its access privileges. If the root account has an empty password, your MySQL installation is unprotected: Anyone can connect to the MySQL server as root without a password and be granted all ...
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/replication-howto-repuser.html
Any account can be used for this operation, providing it has been granted the REPLICATION SLAVE privilege. To grant this account the privileges required for replication, use the GRANT statement. Each replica connects to the source using a MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/security-against-attack.html
Do not grant the PROCESS or SUPER privilege to nonadministrative users. If you do not trust your DNS, you should use IP addresses rather than host names in the grant tables. In any case, you should be very careful about creating grant table entries ... When you connect to a MySQL server, you should use a ...
https://dev.mysql.com/doc/refman/5.7/en/security-guidelines.html
Use the GRANT and REVOKE statements to control access to MySQL. Use the SHOW GRANTS statement to check which accounts have access to what. Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common ...
https://dev.mysql.com/doc/refman/5.7/en/stored-routines-privileges.html
The MySQL grant system takes stored routines into account as follows: The CREATE ROUTINE privilege is needed to create stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator ...The ALTER ROUTINE privilege is needed to alter or drop stored ...