Search Results
https://dev.mysql.com/doc/refman/9.7/en/events-privileges.html
In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM jon@ghidora; Important Revoking the EVENT privilege from a user does not delete or disable any events that may ...The EVENT privilege governs the creation, modification, and deletion of ... To enable or disable the execution of scheduled events, ...
https://dev.mysql.com/doc/mysql-shell/9.7/en/mysql-shell-ldap-kerberos-authentication.html
To use simple LDAP authentication with MySQL Shell, the following conditions must be satisfied: A user account must be created on the MySQL server that is set up to communicate with the LDAP server. For example: CREATE USER 'admin'@'localhost' ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-filtering.html
It is theoretically possible for a user with sufficient permissions to mistakenly create an “abort” item in the audit log filter that prevents themselves and other administrators from accessing the system. Accounts created with the SYSTEM_USER ...Multiple filters can be defined, and any given filter can be assigned to any number of user ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-filtering.html
It is theoretically possible for a user with sufficient permissions to mistakenly create an “abort” item in the audit log filter that prevents themselves and other administrators from accessing the system. Accounts created with the SYSTEM_USER ...Multiple filters can be defined, and any given filter can be assigned to any number of user ... Note For audit log filtering to work as described ...
https://dev.mysql.com/doc/refman/9.7/en/multifactor-authentication.html
That is, it places constraints on CREATE USER and ALTER USER statements with respect to multifactor authentication. CREATE USER and ALTER USER have syntax enabling multiple authentication methods to be specified for new accounts, and for adding, ...
https://dev.mysql.com/doc/refman/9.7/en/request-access.html
These privileges can come from any of the user, global_grants, db, tables_priv, columns_priv, or procs_priv tables. (You may find it helpful to refer to Section 8.2.3, “Grant Tables”, which lists the columns present in each grant table.) The ...
https://dev.mysql.com/doc/refman/9.7/en/sys-user-summary-by-statement-latency.html
The user_summary_by_statement_latency and x$user_summary_by_statement_latency views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table is NULL are assumed to be for background ...
https://dev.mysql.com/doc/refman/9.7/en/firewall-component.html
This differs from the usual MySQL convention for statements such as CREATE USER and GRANT, for which you quote the user and host parts of an account name separately ('user_name'@'host_name'). The FIREWALL_ADMIN privilege enables users to administer ... Purpose: Provide an application-level firewall enabling the database administrator to allow or block SQL statements based on matching them against accepted statement ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-parameters.html
innodb_default_row_format Command-Line Format --innodb-default-row-format=value System Variable innodb_default_row_format Scope Global Dynamic Yes SET_VAR Hint Applies No Type Enumeration Default Value DYNAMIC Valid Values REDUNDANTCOMPACTDYNAMIC ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-component-configuration.html
The Connection Control component exposes the following system variables: component_connection_control.failed_connections_threshold: This is the number of consecutive failed connection attempts by a given account which are allowed before the server ...To disable counting of failed connections, set this variable to ...