Search Results
https://dev.mysql.com/doc/refman/8.4/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 ... Note For audit log filtering to work as ...
https://dev.mysql.com/doc/refman/8.4/en/user-resources.html
To establish resource limits for an account at account-creation time, use the CREATE USER statement. One means of restricting client use of MySQL server resources is to set the global max_user_connections system variable to a nonzero value. In ...
https://dev.mysql.com/doc/refman/8.4/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/8.4/en/sys-user-summary.html
These views summarize statement activity, file I/O, and connections, grouped by user. The user_summary and x$user_summary views have these columns: user The client user name. Rows for which the USER column in the underlying Performance Schema table ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
The authentication_string value can be specified using an IDENTIFIED ...AS clause with CREATE USER or ALTER USER. The plugin uses the SO_PEERCRED socket option to obtain information about the user running the client program. To uninstall it, use ...
https://dev.mysql.com/doc/extending-mysql/8.4/en/writing-authentication-plugins-server-side.html
Suppose that you create an account using the following statement: CREATE USER 'my_user'@'localhost' IDENTIFIED WITH my_plugin AS 'my_auth_string'; When my_user connects from the local host, the server invokes my_plugin and passes 'my_auth_string' to ...This is useful if the server plugin does not care about the client plugin or what user name or password it ... Declare the server-side plugin with the usual general descriptor format ...
https://dev.mysql.com/doc/x-devapi-userguide/en/devapi-users-working-with-relational-tables.html
The X DevAPI SQL CRUD functions allow you to work with relational tables in manners similar to using traditional SQL statements. The following code sample shows how to use the add() and select() methods of the X DevAPI SQL CRUD functions, which are ...
https://dev.mysql.com/doc/refman/8.4/en/sys-user-summary-by-statement-type.html
These views summarize information about statements executed, grouped by user and statement type. By default, rows are sorted by user and descending total latency. The user_summary_by_statement_type and x$user_summary_by_statement_type views have ...
https://dev.mysql.com/doc/refman/8.4/en/clone-plugin-remote.html
Use this option if you do not want to remove existing user-created data (schemas, tables, tablespaces) and binary logs from the recipient data directory. When the optional DATA DIRECTORY [=] 'clone_dir' clause is not used, a cloning operation ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-uri-or-key-value-pairs.html
Parameters specified with key-value pairs use a syntax such as {user:'myuser', host:'example.com', port:3306, schema:'main-schema'}. user: The MySQL user account to provide for the authentication process. For example: ... This section describes use ...