Search Results
https://dev.mysql.com/doc/mysql-monitor/8.0/en/sql-mode-check-startup.html
On startup, the agent sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER on the monitored MySQL instance. The local agent of MySQL Enterprise Service Manager also sets sql_mode=STRICT_TRANS_TABLES,NO_ENGINE_SUBSTITUTION on ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-roles-dynamic-privileges.html
Privilege management is an important aspect of managing the security of a MySQL installation. Following the principle of least privilege, a MySQL account should only be granted privileges required to for its legitimate purposes. To facilitate ...A ...
https://dev.mysql.com/doc/refman/8.4/en/replication-statements-group.html
This section provides information about the statements used for controlling group replication.
https://dev.mysql.com/doc/refman/8.4/en/set-sql-log-bin.html
SET sql_log_bin = {OFF|ON} The sql_log_bin variable controls whether logging to the binary log is enabled for the current session (assuming that the binary log itself is enabled). To disable or enable binary logging for the current session, set the ...Set this variable to OFF for a session to temporarily disable binary logging while making changes to the source that you do not want replicated to the ...
https://dev.mysql.com/doc/refman/8.4/en/sql-data-definition-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-data-manipulation-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-server-administration-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/sql-transactional-statements.html
MySQL supports local transactions (within a given client session) through statements such as SET autocommit, START TRANSACTION, COMMIT, and ROLLBACK. XA transaction support enables MySQL to participate in distributed transactions as well.
https://dev.mysql.com/doc/refman/8.4/en/sql-utility-statements.html
...
https://dev.mysql.com/doc/refman/8.4/en/connection-interfaces.html
This section describes aspects of how the MySQL server manages client connections. Individual server plugins or components may implement their own connection interface: X Plugin enables MySQL Server to communicate with clients using X Protocol.