PDF (US Ltr)
- 35.0Mb
PDF (A4)
- 35.1Mb
Man Pages (TGZ)
- 254.9Kb
Man Pages (Zip)
- 359.8Kb
Info (Gzip)
- 3.4Mb
Info (Zip)
- 3.4Mb
Search Results
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/alter-event.html
(See Section 13.1.12, “CREATE EVENT Statement”.) Any user can alter an event defined on a database for which that user has the EVENT privilege. and db_name.event_name notation, as shown here: ALTER EVENT olddb.myevent RENAME TO newdb.myevent; To ... ALTER [DEFINER = user] EVENT event_name [ON SCHEDULE schedule] [ON COMPLETION [NOT] PRESERVE] [RENAME TO new_event_name] [ENABLE | DISABLE | DISABLE ON SLAVE] [COMMENT 'string'] [DO event_body] The ALTER EVENT statement changes one or more of the characteristics of an existing event without the need to drop and recreate ...
https://dev.mysql.com/doc/refman/5.7/en/audit-log-reference.html
The tables can be accessed only by users who have privileges for that database. Unless those objects are installed, the audit_log plugin operates in legacy mode. Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for ...
https://dev.mysql.com/doc/refman/5.7/en/binary-log.html
A client that has privileges sufficient to set restricted session system variables (see Section 5.1.8.1, “System Variable Privileges”) can disable binary logging of its own statements by using a SET sql_log_bin=OFF statement. The binary log ...