Search Results
https://dev.mysql.com/doc/refman/8.4/en/stored-objects-security.html
If a definition omits the DEFINER attribute, the default object definer is the user who creates it. (That is, the statement fails if renaming an account would cause a stored object to become orphaned.) CREATE USER fails with an error if any account ...Additionally, to set a stored object DEFINER attribute to an account that has the SYSTEM_USER privilege, you must have the SYSTEM_USER ... Stored programs (procedures, functions, ...
https://dev.mysql.com/doc/refman/8.4/en/option-defaults-equals.html
Consider the following example, where a user connects to a MySQL server running on host tonfisk as user jon: $> mysql --host 85.224.35.45 --user jon Welcome to the MySQL monitor. Suppose the my.cnf file is as shown here: [mysql] user jon Trying to ...Due to this behavior, problems can occasionally arise when no value is provided for an option that expects ...
https://dev.mysql.com/doc/refman/8.4/en/validate-password-options-variables.html
This applies only when changing an existing password, and has no effect when setting a user account's initial password. If the ALTER USER statement does not provide the existing password in a REPLACE clause, this variable is not enforced. This ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-reference.html
Audit Log Tables MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. The tables can be accessed only by users who have privileges for that database. The table has these columns: ...
https://dev.mysql.com/doc/heatwave-aws/en/heatwave-aws-user-configurable-shape-dependent-system-variables.html
User-Configurable Shape-Dependent System Variables 19.6 User-Configurable Shape-Dependent System Variables Shape-dependent global system variables are linked to, and tuned for, a specific MySQL shape. Note: innodb_buffer_pool_instances , ...
https://dev.mysql.com/doc/mysql-monitor/8.0/en/mem-acl-monitoring-mem-permissions.html
Note Advisors do not run as the user who created or enabled them, but as the system role. Users associated with this role can create, edit, suspend, and delete Event Handlers. If Server Group is set to Administer, assigned users can delete and ...
https://dev.mysql.com/doc/refman/8.4/en/change-replication-source-to.html
If the user account that you create or use for replication uses this authentication plugin, and you are not using a secure connection, you must enable RSA key pair-based password exchange for a successful connection. In that case, do not specify the ...] CHANGE REPLICATION SOURCE TO changes the parameters that the replica server uses for connecting to the source and reading data from the ...
https://dev.mysql.com/doc/ndbapi/en/ndb-error-codes-user-defined-error.html
The following list enumerates all NDB errors of type UD (User defined error).
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-variable-tables.html
The Performance Schema provides a user_variables_by_thread table that exposes user-defined variables. These are variables defined within a specific session and include a @ character preceding the name; see Section 11.4, “User-Defined Variables”. The user_variables_by_thread table has these columns: THREAD_ID The thread identifier of the session in which the variable is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-nutshell.html
use in GRANT statements now causes a syntax error Instead of SET_USER_ID, you can use the SET_ANY_DEFINER privilege for definer object creation, and the ALLOW_NONEXISTENT_DEFINER privileges for orphan object protection. In either case, the user is ... This section summarizes what has been added to, deprecated in, changed, and removed from MySQL 8.4 since MySQL ...