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/drop-procedure.html
(If the automatic_sp_privileges system variable is enabled, that privilege and EXECUTE are granted automatically to the routine creator when the routine is created and dropped from the creator when the routine is dropped. (DROP FUNCTION is also used ... DROP {PROCEDURE | FUNCTION} [IF EXISTS] sp_name These statements are used to drop a stored routine (a stored procedure or ...
https://dev.mysql.com/doc/refman/5.7/en/event-scheduler.html
Section 23.4.6, “The Event Scheduler and MySQL Privileges”, discusses the privileges required to work with events and the ramifications that events have with regard to privileges when executing. If you are upgrading to MySQL 5.7 from an earlier ... The MySQL Event Scheduler manages the scheduling and execution of events, that is, tasks that run according to a ...
https://dev.mysql.com/doc/refman/5.7/en/events-configuration.html
When running, the event scheduler thread and its current state can be seen by users having the PROCESS privilege in the output of SHOW PROCESSLIST, as shown in the discussion that follows. Starting the MySQL server with the --skip-grant-tables ...
https://dev.mysql.com/doc/refman/5.7/en/lock-tables.html
You must have the LOCK TABLES privilege, and the SELECT privilege for each object to be locked. As of MySQL 5.7.32, LOCK TABLES checks that the view definer has the proper privileges on the tables underlying the view. If a session issues a LOCK ...
https://dev.mysql.com/doc/refman/5.7/en/rename-table.html
Any privileges granted specifically for a renamed table or view are not migrated to the new name. You must have ALTER and DROP privileges for the original table, and CREATE and INSERT privileges for the new table. RENAME TABLE tbl_name TO ...
https://dev.mysql.com/doc/refman/5.7/en/replication-features-flush.html
If you replicate the privilege tables in the mysql database and update those tables directly without using GRANT, you must issue a FLUSH PRIVILEGES on the replicas to put the new privileges into effect. Some forms of the FLUSH statement are not ...
https://dev.mysql.com/doc/refman/5.7/en/too-many-connections.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator who also has the PROCESS privilege can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of ...The extra connection is reserved for use by accounts that have the SUPER ... If clients encounter Too many connections errors when attempting to ...
https://dev.mysql.com/doc/refman/5.7/en/information-schema-schemata-table.html
The following statements are equivalent: SELECT SCHEMA_NAME AS `Database` FROM INFORMATION_SCHEMA.SCHEMATA [WHERE SCHEMA_NAME LIKE 'wild'] SHOW DATABASES [LIKE 'wild'] You see only those databases for which you have some kind of privilege, unless ...
https://dev.mysql.com/doc/refman/5.7/en/performance-schema-variable-table-migration.html
Migration and Privileges Initially, with the introduction of Performance Schema system and status variable tables in MySQL 5.7.6, access to those tables required the SELECT privilege, just as for other Performance Schema tables. However, this had ...
https://dev.mysql.com/doc/refman/5.7/en/faqs-replication.html
How do I prevent GRANT and REVOKE statements from replicating to replica machines? A.14.13. How do I prevent GRANT and REVOKE statements from replicating to replica machines? Start the server with the --replicate-wild-ignore-table=mysql.% option to ... In the following section, we provide answers to questions that are most frequently asked about MySQL ...