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/mysql-secure-deployment-guide/8.0/en/secure-deployment-post-install.html
Post-installation setup involves creating a safe directory for import and export operations, configuring server startup options, initializing the data directory, starting MySQL using systemd, resetting the password for the MySQL root@localhost user ...By default, a user who has the FILE privilege can read any file on the server host that is either world-readable or readable by the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/replication-privilege-checks.html
You can create a user account with the appropriate privileges to apply the transactions that are normally replicated on a channel, and specify this as the PRIVILEGE_CHECKS_USER account for the replication applier, using a CHANGE REPLICATION SOURCE ...MySQL then checks each transaction against the user account's privileges to verify that you have authorized the operation for that ... By default, MySQL replication (including Group Replication) does ...
https://dev.mysql.com/doc/refman/8.4/en/glossary.html
global temporary tablespace A temporary tablespace that stores rollback segments for changes made to user-created temporary tables. session temporary tablespace A temporary tablespace that stores user-created temporary tables and internal temporary ...Experienced users can adjust the isolation level, trading off less protection in favor of increased performance and concurrency, when they can be sure that the transactions really do not interfere with each ...
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/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/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/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 ...