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/events-overview.html
A user may include statements in an event's action which require privileges that the user does not actually have. See Section 23.4.6, “The Event Scheduler and MySQL Privileges” for details. An event can be modified by any user having the EVENT ... MySQL Events are tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-general-table-reference.html
The following table summarizes INFORMATION_SCHEMA general tables. For greater detail, see the individual table descriptions. Table 24.2 INFORMATION_SCHEMA General Tables Table Name Description CHARACTER_SETS Available character sets ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 24.1 INFORMATION_SCHEMA Tables Table Name Description Introduced Deprecated CHARACTER_SETS Available character ...
https://dev.mysql.com/doc/refman/5.7/en/innodb-configuring-io-capacity.html
You can set the innodb_io_capacity value in the MySQL option file (my.cnf or my.ini) or modify it at runtime using a SET GLOBAL statement, which requires privileges sufficient to set global system variables. You can set the innodb_flush_sync value ... The InnoDB master thread and other threads perform various tasks in the background, most of which are I/O related, such as flushing dirty pages from the buffer pool and writing changes from the change buffer to the appropriate secondary ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-security-mysql-security-procedures.html
As mentioned in the previous section (see Section 21.6.18.2, “NDB Cluster and MySQL Privileges”), you should always set a root password for the MySQL Server as soon as you have it running. Be sure to run the FLUSH PRIVILEGES statement as soon as ... In this section, we discuss MySQL standard security procedures as they apply to running NDB ...
https://dev.mysql.com/doc/refman/5.7/en/mysqlbinlog.html
Manipulating the session value of the sql_log_bin system variable is a restricted operation, so this option requires that you have privileges sufficient to set restricted session variables. The server's binary log consists of files containing ...
https://dev.mysql.com/doc/refman/5.7/en/replication-gtids-howto.html
Most of the steps that follow require the use of the MySQL root account or another MySQL user account that has the SUPER privilege. mysqladmin shutdown requires either the SUPER privilege or the SHUTDOWN privilege. Stop each server using mysqladmin ... This section describes a process for configuring and starting GTID-based replication in MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/replication-options-gtids.html
The session user must have privileges sufficient to set restricted session variables. The MySQL Server system variables described in this section are used to monitor and control Global Transaction Identifiers (GTIDs). For additional information, ...
https://dev.mysql.com/doc/refman/5.7/en/set-password.html
Setting the password for a named account (with a FOR clause) requires the UPDATE privilege for the mysql system database. Setting the password for yourself (for a nonanonymous account with no FOR clause) requires no special privileges. When the ...
https://dev.mysql.com/doc/refman/5.7/en/show-columns.html
SHOW COLUMNS displays information only for those columns for which you have some privilege. These two statements are equivalent: SHOW COLUMNS FROM mytable FROM mydb; SHOW COLUMNS FROM mydb.mytable; The optional FULL keyword causes the output to ...