Search Results
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/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/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/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/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/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/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/refman/8.4/en/replication-features-current-user.html
In some cases, such as statements that change passwords, the function reference is expanded before it is written to the binary log, so that the statement includes the user name. For all other cases, the name of the current user on the source is ...
https://dev.mysql.com/doc/refman/8.4/en/assigning-passwords.html
Operations that assign or modify passwords are permitted only to users with the CREATE USER privilege, or, alternatively, privileges for the mysql database (INSERT privilege to create new accounts, UPDATE privilege to modify existing accounts). If ...MySQL stores credentials in the user table in the mysql system ... Required credentials ...