Search Results
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
By granting the privilege to administrators and not to normal users (who should not need it), an administrator can connect to the server and use SHOW PROCESSLIST to diagnose problems even if the maximum number of unprivileged clients are connected.
https://dev.mysql.com/doc/refman/8.4/en/create-event.html
As granting such privileges entails a potential for abuse, extreme care must be taken in doing so. CREATE [DEFINER = user] EVENT [IF NOT EXISTS] event_name ON SCHEDULE schedule [ON COMPLETION [NOT] PRESERVE] [ENABLE | DISABLE | DISABLE ON {REPLICA ...
https://dev.mysql.com/doc/refman/8.4/en/create-function-loadable.html
If the server is started with the --skip-grant-tables option, functions registered in the table are not loaded and are unavailable. CREATE [AGGREGATE] FUNCTION [IF NOT EXISTS] function_name RETURNS {STRING|INTEGER|REAL|DECIMAL} SONAME ...
https://dev.mysql.com/doc/refman/8.4/en/create-view.html
The standard says that the definer of the view, which is the same as the owner of the view's schema, gets applicable privileges on the view (for example, SELECT) and may grant them. If the view does not exist, CREATE OR REPLACE VIEW is the same as ...
https://dev.mysql.com/doc/refman/8.4/en/data-masking.html
Administration is restricted to authorized users who are granted special privileges so that only they can create and modify the dictionaries. Note MySQL Enterprise Data Masking and De-Identification is an extension included in MySQL Enterprise ...
https://dev.mysql.com/doc/refman/8.4/en/database-use.html
The administrator needs to execute a statement like this: mysql> GRANT ALL ON menagerie.* TO 'your_mysql_name'@'your_client_host'; where your_mysql_name is the MySQL user name assigned to you and your_client_host is the host from which you connect ... Once you know how to enter SQL statements, you are ready to access a ...
https://dev.mysql.com/doc/refman/8.4/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 {PROCEDURE | ...
https://dev.mysql.com/doc/refman/8.4/en/drop-user.html
It removes privilege rows for the account from all grant tables. The DROP USER statement removes one or more MySQL accounts and their privileges. Roles named in the mandatory_roles system variable value cannot be dropped. To use DROP USER, you must ...
https://dev.mysql.com/doc/refman/8.4/en/events-configuration.html
Starting the MySQL server with the --skip-grant-tables option causes event_scheduler to be set to DISABLED, overriding any other value set either on the command line or in the my.cnf or my.ini file (Bug #26807). Events are executed by a special ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-stored-procs.html
If replication or binary logging in general (for the purpose of point-in-time recovery) is active, then MySQL DBAs have two security options open to them: Any user wishing to create stored functions must be granted the SUPER privilege. Where can I ...