Search Results
https://dev.mysql.com/doc/refman/8.4/en/innodb-data-encryption.html
A DBA can grant this privilege to enable a user to deviate from the default_table_encryption setting when creating or altering a schema or general tablespace, or to deviate from the default schema encryption when creating or altering a table. You ...
https://dev.mysql.com/doc/mysql-secure-deployment-guide/8.0/en/secure-deployment-audit.html
audit-log=FORCE_PLUS_PERMANENT Restart the server to apply the configuration change: $> systemctl restart mysqld By default, rule-based audit log filtering logs no auditable events for any users. For security reasons, the file should be written to a ... MySQL Enterprise Audit enables standard, policy-based monitoring and logging of connection and query activity, providing an auditing and compliance solution for applications that are governed by both internal and external regulatory ...
https://dev.mysql.com/doc/refman/8.4/en/information-schema-table-reference.html
The following table summarizes all available INFORMATION_SCHEMA tables. For greater detail, see the individual table descriptions. Table 28.1 INFORMATION_SCHEMA Tables Table Name Description Deprecated ADMINISTRABLE_ROLE_AUTHORIZATIONS Grantable ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-replication-schema.html
User intervention is normally not required to create or maintain either of these tables, since both are maintained by the NDB binary log (binlog) injector thread. Some conflict resolution functions (NDB$OLD(), NDB$EPOCH(), NDB$EPOCH_TRANS()) require ...The ndb_binlog_index and ndb_apply_status tables are created in the mysql ... ndb_apply_status Table ndb_binlog_index Table ndb_replication Table Replication in NDB Cluster makes use of a number of dedicated tables in the mysql database on each MySQL Server ...
https://dev.mysql.com/doc/refman/8.4/en/view-restrictions.html
If a user is granted the basic privileges necessary to create a view (the CREATE VIEW and SELECT privileges), that user cannot call SHOW CREATE VIEW on that object unless the user is also granted the SHOW VIEW privilege. The workaround to the ...
https://dev.mysql.com/doc/refman/8.4/en/system-variable-privileges.html
Suppose that an administrator has created the following role to confer the ability to set restricted session system variables: CREATE ROLE set_session_sysvars; GRANT SYSTEM_VARIABLES_ADMIN ON *.* TO set_session_sysvars; Any user granted the ...In ...
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-user-defined-functions-table.html
The user_defined_functions table contains a row for each loadable function registered automatically by a component or plugin, or manually by a CREATE FUNCTION statement. The user_defined_functions table lists loadable functions installed using ...
https://dev.mysql.com/doc/refman/8.4/en/select-into.html
Note Any file created by INTO OUTFILE or INTO DUMPFILE is owned by the operating system user under whose account mysqld runs. For the INTO var_list variant: var_list names a list of one or more variables, each of which can be a user-defined ...INTO ...
https://dev.mysql.com/doc/refman/8.4/en/memory-storage-engine.html
User-Created and Temporary Tables MEMORY table contents are stored in memory, which is a property that MEMORY tables share with internal temporary tables that the server creates on the fly while processing queries. The MEMORY storage engine ...
https://dev.mysql.com/doc/relnotes/connector-cpp/en/news-8-0-5.html
If a user creates a table with text columns that use a non-UTF-8 character set, and this column holds a string with non-ASCII characters, errors will occur for attempts to access that string (for example, in a query result). (WL #10785) X DevAPI ...