Search Results
https://dev.mysql.com/doc/refman/8.4/en/events-privileges.html
Suppose also that this user has the SELECT privilege for myschema, but no other privileges for this schema. In this example, the EVENT privilege on the schema myschema is removed from the jon@ghidora user account: REVOKE EVENT ON myschema.* FROM ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
Passwords can be expired manually, and on the basis of a policy for automatic expiration (see Section 8.2.15, “Password Management”). For any operation not permitted within the session, the server returns an ER_MUST_CHANGE_PASSWORD error: mysql> ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-connectors-apis.html
For common questions, issues, and answers relating to the MySQL Connectors and other APIs, see the following areas of the Manual: Using C API Features Connector/ODBC Notes and Tips Connector/NET Programming MySQL Connector/J Developer Guide .
https://dev.mysql.com/doc/refman/8.4/en/faqs-replication.html
The implication of this is that, at any given time, the replica is not guaranteed to be in synchrony with the source unless you take some special measures. (This is why TIMESTAMP is well replicated.) In the Time column in the output of SHOW ... In ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-tablespace-encryption.html
For example, assets such as pharmaceutical research results, oil field exploration results, financial contracts, or personal data of law enforcement informants may require encryption. How is InnoDB data-at-rest encryption different from encryption ...Is data decrypted for users who are authorized to see it? ...
https://dev.mysql.com/doc/refman/8.4/en/features.html
This section describes some of the important characteristics of the MySQL Database Software. This is useful if you want to provide an SQL interface for an in-house database. It is possible to change this when the MySQL server is started (see ...In ...
https://dev.mysql.com/doc/refman/8.4/en/file-permissions.html
If this is unsuitable, create the error file manually with the desired access mode prior to executing mysqld_safe. If you have problems with file permissions, the UMASK or UMASK_DIR environment variable might be set incorrectly when mysqld starts.
https://dev.mysql.com/doc/refman/8.4/en/fips-mode.html
This includes replication (source/replica and Group Replication) and X Plugin, which run within the server. This means you have the following options, depending on system and MySQL configuration: Use a system that has OpenSSL 3.0 and the required ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-deploying-in-multi-primary-or-single-primary-mode.html
You cannot change the value of group_replication_single_primary_mode manually while Group Replication is running. Group Replication operates either in single-primary mode or in multi-primary mode. The group's mode is a group-wide configuration ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-enterprise-backup.html
This section explains how to back up and subsequently restore a Group Replication member using MySQL Enterprise Backup. In this example, we assume the hosts are both Linux servers and use SCP to copy the files between them: s2/backups> scp ... MySQL ...