Search Results
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-choosing-id.html
The range of IDs from 1024 to 2047 is reserved for user-defined collations. To add a collation, you must choose an ID value that is not currently used. The collation ID that you choose appears in these contexts: The ID column of the Information ...
https://dev.mysql.com/doc/refman/8.4/en/adding-collation-simple-8bit.html
You can check the variable value as follows, although the path name might be different on your system: mysql> SHOW VARIABLES LIKE 'character_sets_dir'; +--------------------+-----------------------------------------+ | Variable_name | Value | ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-restrictions.html
MySQL Enterprise Audit is subject to these general restrictions: Only SQL statements are logged. Changes made by no-SQL APIs, such as memcached, Node.JS, and the NDB API, are not logged. Only top-level statements are logged, not statements within ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log-security.html
For security reasons, audit log files should be written to a directory accessible only to the MySQL server and to users with a legitimate reason to view the log. By default, contents of audit log files produced by the audit log plugin are not ...
https://dev.mysql.com/doc/refman/8.4/en/audit-log.html
By default, MySQL Enterprise Audit uses tables in the mysql system database for persistent storage of filter and user account data. Note MySQL Enterprise Audit is an extension included in MySQL Enterprise Edition, a commercial product. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/binlog.html
To execute BINLOG statements when applying mysqlbinlog output, a user account requires the BINLOG_ADMIN privilege (or the deprecated SUPER privilege), or the REPLICATION_APPLIER privilege plus the appropriate privileges to execute each log event. It ...
https://dev.mysql.com/doc/refman/8.4/en/blob.html
For security and other reasons, it is usually preferable to do so using application code rather than giving application users the FILE privilege. A BLOB is a binary large object that can hold a variable amount of data. These differ only in the ...
https://dev.mysql.com/doc/refman/8.4/en/charset-collation-coercibility.html
A “system constant” (the string returned by functions such as USER() or VERSION()) has a coercibility of 3. In the great majority of statements, it is obvious what collation MySQL uses to resolve a comparison operation. For example, in the ...
https://dev.mysql.com/doc/refman/8.4/en/common-errors.html
This section lists some errors that users frequently encounter when running MySQL programs. Although the problems show up when you try to run client programs, the solutions to many of the problems involves changing the configuration of the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/communication-errors.html
If the log_error_verbosity system variable is set to 3, you might find messages like this in your error log: [Note] Aborted connection 854 to db: 'employees' user: 'josh' If a client is unable even to connect, the server increments the ... If ...