Search Results
https://dev.mysql.com/doc/refman/8.4/en/grant-tables.html
When using -binlog_format=mixed, DML operations that read data from grant tables are written to the binary log as row events to make the operations safe for mixed-mode replication. If a key value is implicitly or explicitly 0, the corresponding ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-programs-ndb-restore.html
Note Before using ndb_restore, it is recommended that the cluster be running in single user mode, unless you are restoring multiple data nodes in parallel. See Section 25.6.6, “NDB Cluster Single User Mode”, for more information. The NDB ...
https://dev.mysql.com/doc/refman/8.4/en/privileges-provided.html
Note The Performance Schema threads table also provides thread information, but table access uses a different privilege model. A server in offline mode (offline_mode enabled) does not terminate SUPER client connections at the next client request, ...
https://dev.mysql.com/doc/workbench/en/wb-preferences-sql-editor.html
For this reason, this facility can be switched off for models containing large numbers of schemas and tables. Safe Updates (rejects UPDATEs and DELETEs with no restrictions) Enabled by default. If disabled, you can instead use the keyboard shortcut ... This section provides configuration options that affect the SQL editor functionality in MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/binary-log-setting.html
In MySQL 8.4, binary logging is enabled by default, and is disabled only if you start the server with --skip-log-bin or --disable-log-bin. When using STATEMENT mode, the binlog_format system variable is not replicated. When using MIXED or ROW ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-filtering.html
Audit Log plugin will run in the legacy mode, which will be disabled in the next release.' In legacy mode, which is deprecated, filtering can be done based only on event account or status. If the plugin is installed without the accompanying audit ...
https://dev.mysql.com/doc/refman/8.4/en/using-date.html
To be on the safe side, assume that strings are compared as strings and use the appropriate string functions if you want to compare a temporal value to a string. If you enable the ALLOW_INVALID_DATES SQL mode, MySQL permits you to store dates that ...You should use this format in UPDATE expressions and in the WHERE clause of SELECT ...
https://dev.mysql.com/doc/refman/8.4/en/timestamp-initialization.html
In addition, if the explicit_defaults_for_timestamp system variable is disabled, you can initialize or update any TIMESTAMP (but not DATETIME) column to the current date and time by assigning it a NULL value, unless it has been defined with the NULL ... TIMESTAMP and DATETIME columns can be automatically initialized and updated to the current date and time (that is, the current ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-connect.html
$> cd /usr/local/mysql $> bin/mysql --user=user2 -p --ssl-mode=DISABLED --host=192.0.2.24 --server-public-key-path=/path/to/public_key.pem The --host option specifies the host where the MySQL server is running. $> cd /usr/local/mysql $> bin/mysql ...
https://dev.mysql.com/doc/workbench/en/workbench-faq.html
To alter this behavior, open your Workbench Preferences, select the SQL Editor section, and disable the following preference: [ ] "Safe Updates". How does MySQL Workbench increase import performance? When a model is exported (Database, Forward ...