Search Results
https://dev.mysql.com/doc/relnotes/mysql/9.7/en/news-9-0-0.html
These changes also entail the removal of the following server options and variables: The --mysql-native-password server option The --mysql-native-password-proxy-users server option The default_authentication_plugin server system variable For more ...
https://dev.mysql.com/doc/extending-mysql/9.7/en/writing-audit-plugins.html
The general plugin descriptor also refers to simple_status and system_variables, structures that expose several status and system variables. system_variables is an array of system variable elements, each of which is defined using a MYSQL_THDVAR_xxx ... This section describes how to write a server-side audit plugin, using the example plugin found in the plugin/audit_null directory of MySQL source ...
https://dev.mysql.com/doc/refman/9.7/en/load-data-local-security.html
MySQL Shell's data upload utilities use LOAD DATA LOCAL INFILE statements to upload data, so the local_infile system variable must be set to ON on the target server instance. Dump loading utility util.loadDump() Import dump files created using MySQL ...The statement can load a file located on the server host, or, if the LOCAL keyword is specified, on the client ...
https://dev.mysql.com/doc/refman/9.7/en/replication-functions-async-failover.html
For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable. For the GroupReplication managed service, the identifier is the value of the group_replication_group_name system variable. The ...
https://dev.mysql.com/doc/refman/9.7/en/host-cache.html
To disable DNS host name lookups, start the server with the skip_name_resolve system variable enabled. To disallow TCP/IP connections entirely, start the server with the skip_networking system variable enabled. Unblock with 'mysqladmin flush-hosts' ...The server uses the host cache for several purposes: By caching the results of IP-to-host name lookups, the server avoids doing a Domain Name System (DNS) lookup for each client ...
https://dev.mysql.com/doc/refman/9.7/en/connection-control-plugin-installation.html
To be usable by the server, the plugin library file must be located in the MySQL plugin directory (the directory named by the plugin_dir system variable). Connection Delay Configuration Connection Failure Assessment Connection Failure Monitoring ...
https://dev.mysql.com/doc/refman/9.7/en/audit-log-component-reference.html
To use a different database, set the audit_log.database system variable at server startup. If there are invalid filter configurations in the audit_log_filter table, the audit_log.filter_recovery_mode system variable controls the recovery mode of the ...You can set any of these variables at server startup, and some of them at ...Audit Log Tables MySQL Enterprise Audit uses tables in ...
https://dev.mysql.com/doc/refman/9.7/en/innodb-init-startup-configuration.html
(The MySQL server changes its current working directory to the data directory when it begins executing.) Alternatively, you can specify an absolute path for system tablespace data files. Normally, InnoDB is initialized when the MySQL server is ...
https://dev.mysql.com/doc/refman/9.7/en/connection-interfaces.html
To control and monitor how the server manages threads that handle client connections, several system and status variables are relevant. (See Section 7.1.8, “Server System Variables”, and Section 7.1.10, “Server Status Variables”.) The ...If ... This section describes aspects of how the MySQL server manages client ...On ...
https://dev.mysql.com/doc/refman/9.7/en/programs-overview.html
mysqld_multi A server startup script that can start or stop multiple servers installed on the system. Oracle Corporation also provides the MySQL Workbench GUI tool, which is used to administer MySQL servers and databases, to create, execute, and ...