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/firewall-usage.html
Grant the SUPER privilege so that the firewall administrative functions can be executed. Enabling or Disabling the Firewall Assigning Firewall Privileges Firewall Concepts Registering Firewall Account Profiles Monitoring the Firewall Enabling or ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-metadata-locks-table.html
The Performance Schema exposes metadata lock information through the metadata_locks table: Locks that have been granted (shows which sessions own which current metadata locks). Locks that have been requested but not yet granted (shows which sessions ... MySQL uses metadata locking to manage concurrent access to database objects and to ensure data consistency; see Section 8.11.4, “Metadata ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-nutshell.html
MySQL now sets the access control granted to clients on the named pipe to the minimum necessary for successful communication on Windows. The value of the show_compatibility_56 system variable affects the output produced from and privileges required ... This section summarizes what has been added to, deprecated in, and removed from MySQL ...
https://dev.mysql.com/doc/refman/5.7/en/create-procedure.html
By default, MySQL automatically grants the ALTER ROUTINE and EXECUTE privileges to the routine creator. If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 23.6, “Stored Object Access ...By ...
https://dev.mysql.com/doc/refman/5.7/en/stored-programs-logging.html
Replicated statements executed on a replica are processed by the replica SQL thread, which has full privileges. It is possible for a procedure to follow different execution paths on source and replica servers, so a user can write a routine ... The ...
https://dev.mysql.com/doc/refman/5.7/en/mysqladmin.html
This is true even if you precede the password command with flush-privileges on the same command line to re-enable the grant tables because the flush operation occurs after you connect. However, you can use mysqladmin flush-privileges to re-enable ...
https://dev.mysql.com/doc/refman/5.7/en/resetting-permissions.html
Connect to the MySQL server using the mysql client; no password is necessary because the server was started with --skip-grant-tables: $> mysql In the mysql client, tell the server to reload the grant tables so that account-management statements ...
https://dev.mysql.com/doc/refman/5.7/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/refman/5.7/en/mysql-cluster-ndbinfo-locks-per-fragment.html
The locks_per_fragment table provides information about counts of lock claim requests, and the outcomes of these requests on a per-fragment basis, serving as a companion table to operations_per_fragment and memory_per_fragment. This table also ...
https://dev.mysql.com/doc/refman/5.7/en/create-trigger.html
CREATE TRIGGER requires the TRIGGER privilege for the table associated with the trigger. If the DEFINER clause is present, the privileges required depend on the user value, as discussed in Section 23.6, “Stored Object Access Control”. If binary ... CREATE [DEFINER = user] TRIGGER trigger_name trigger_time trigger_event ON tbl_name FOR EACH ROW [trigger_order] trigger_body trigger_time: { BEFORE | AFTER } trigger_event: { INSERT | UPDATE | DELETE } trigger_order: { FOLLOWS | PRECEDES } other_trigger_name This statement creates a new ...