Search Results
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/en/mys-hw-get-privileges.html
To use the additional features of MySQL HeatWave Cluster for different purposes, you might to ask your DB System administrator to create a new user account for you. By default, the DB System provides only one user account for the DB System ...This ...
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/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/mysqldump.html
To reload a dump file, you must have the privileges required to execute the statements that it contains, such as the appropriate CREATE privileges for objects created by those statements. Note A dump made using PowerShell on Windows with output ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-change-user.html
bool mysql_change_user(MYSQL *mysql, const char *user, const char *password, const char *db) Description Changes the user and causes the database specified by db to become the default (current) database on the connection specified by mysql. In ...
https://dev.mysql.com/doc/refman/8.4/en/firewall-reference.html
USERHOST The training account for the group profile, to be used when the profile is in RECORDING mode. The value is NULL, or a non-NULL account that has the format user_name@host_name: If the value is NULL, the firewall records allowlist rules for ...When enabled, the firewall bases operational decisions on the cached ...
https://dev.mysql.com/doc/refman/8.4/en/connection-control-plugin-installation.html
For this purpose, a failed connection attempt is one for which the client user and host match a known MySQL account but the provided credentials are incorrect, or do not match any known account. Failed-connection counting is based on the user/host ... This section describes how to install the connection control plugins, CONNECTION_CONTROL and ...
https://dev.mysql.com/doc/refman/8.4/en/sys-memory-by-user-by-current-bytes.html
The memory_by_user_by_current_bytes and x$memory_by_user_by_current_bytes 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 threads ...By default, rows are sorted by descending amount of memory ...
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 ...