PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.9Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-processlist-table.html
If you have the PROCESS privilege, you can see all threads, even those belonging to other users. Otherwise (without the PROCESS privilege), nonanonymous users have access to information about their own threads but not threads for other users, and ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-threads-table.html
Important For thread information sources other than the threads table, information about threads for other users is shown only if the current user has the PROCESS privilege. That is not true of the threads table; all rows are shown to any user who ... The threads table contains a row for each server ...
https://dev.mysql.com/doc/refman/5.7/en/replication-formats.html
Changing the global binlog_format value requires privileges sufficient to set global system variables. Changing the session binlog_format value requires privileges sufficient to set restricted session system variables. Replication works because ...
https://dev.mysql.com/doc/refman/5.7/en/set-variable.html
Note Setting a global system variable value always requires special privileges. Setting a session system variable value normally requires no special privileges and can be done by any user, although there are exceptions. variable: { user_var_name | ...
https://dev.mysql.com/doc/refman/5.7/en/sys-diagnostics.html
That is a restricted operation, so the procedure requires privileges sufficient to set restricted session variables. Use of the medium or full setting requires the SUPER privilege. Creates a report of the current server status for diagnostic ...
https://dev.mysql.com/doc/refman/5.7/en/sys-schema-prerequisites.html
Before using the sys schema, the prerequisites described in this section must be satisfied. Because the sys schema provides an alternative means of accessing the Performance Schema, the Performance Schema must be enabled for the sys schema to work.
https://dev.mysql.com/doc/refman/5.7/en/trigger-syntax.html
You can refer to it (if you have the SELECT privilege), but not modify it. You can refer to a column named with NEW if you have the SELECT privilege for it. In a BEFORE trigger, you can also change its value with SET NEW.col_name = value if you have ... To create a trigger or drop a trigger, use the CREATE TRIGGER or DROP TRIGGER statement, described in Section 13.1.20, “CREATE TRIGGER Statement”, and Section 13.1.31, “DROP TRIGGER ...
https://dev.mysql.com/doc/refman/5.7/en/using-system-variables.html
For a description of the privilege requirements for setting system variables, see Section 5.1.8.1, “System Variable Privileges” Suffixes for specifying a value multiplier can be used when setting a variable at server startup, but not to set the ... The MySQL server maintains many system variables that configure its ...
https://dev.mysql.com/doc/refman/5.7/en/windows-troubleshooting.html
The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these ...
https://dev.mysql.com/doc/refman/5.7/en/command-line-options.html
Program options specified on the command line follow these rules: Options are given after the command name. An option argument begins with one dash or two dashes, depending on whether it is a short form or long form of the option name. For example, ...