Search Results
https://dev.mysql.com/doc/refman/8.4/en/performance-schema-startup-configuration.html
For example, use these lines in the server my.cnf file: [mysqld] performance_schema=ON If the server is unable to allocate any internal buffer during Performance Schema initialization, the Performance Schema disables itself and sets ... To use the ...
https://dev.mysql.com/doc/refman/8.4/en/replication-features-shutdowns.html
Setting sync_binlog=1 in the source server's my.cnf file helps to minimize this problem because it causes the source to flush its binary log more frequently. To minimize the chance of this occurring, set sync_relay_log_info=1 in the replica my.cnf ... It is safe to shut down a replication source server and restart it ...
https://dev.mysql.com/doc/refman/8.4/en/replication-rules-channel-based-filters.html
The following command options support channel specific replication filters using this format: --replicate-do-db=channel:database_id --replicate-ignore-db=channel:database_id --replicate-do-table=channel:table_id ... This section explains how to work ...
https://dev.mysql.com/doc/refman/8.4/en/socket-pluggable-authentication.html
For example, put these lines in the server my.cnf file: [mysqld] plugin-load-add=auth_socket.so After modifying my.cnf, restart the server to cause the new settings to take effect. The server-side auth_socket authentication plugin authenticates ...
https://dev.mysql.com/doc/refman/8.4/en/test-pluggable-authentication.html
For example, put these lines in the server my.cnf file, adjusting the .so suffix for your platform as necessary: [mysqld] plugin-load-add=auth_test_plugin.so After modifying my.cnf, restart the server to cause the new settings to take effect. MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/upgrade-troubleshooting.html
If problems occur, such as that the new mysqld server does not start, verify that you do not have an old my.cnf file from your previous installation. If this command displays anything other than the program name, you have an active my.cnf file that ... A schema mismatch in a MySQL 8.3 instance between the .frm file of a table and the InnoDB data dictionary can cause an upgrade to MySQL 8.4 to ...
https://dev.mysql.com/doc/refman/8.4/en/using-encrypted-connections.html
For example, put these lines in the server my.cnf file: [mysqld] require_secure_transport=ON Alternatively, to set and persist the value at runtime, use this statement: SET PERSIST require_secure_transport=ON; SET PERSIST sets a value for the ...
https://dev.mysql.com/doc/refman/8.4/en/webauthn-pluggable-authentication.html
$> mysqld [options] --loose-authentication-webauthn-rp-id=mysql.com --plugin-load-add=authentication_webauthn.so To define the relying party and load the plugin, put lines such as this in your my.cnf file, adjusting the .so suffix for your platform ... Note WebAuthn authentication is an extension included in MySQL Enterprise Edition, a commercial ...
https://dev.mysql.com/doc/refman/8.4/en/windows-pluggable-authentication.html
For example, put these lines in the server my.cnf file: [mysqld] plugin-load-add=authentication_windows.dll After modifying my.cnf, restart the server to cause the new settings to take effect. Note Windows pluggable authentication is an extension ...
https://dev.mysql.com/doc/refman/8.4/en/x-plugin-encrypted-connections.html
This section explains how to configure X Plugin to use encrypted connections. To enable configuring support for encrypted connections, X Plugin has mysqlx_ssl_xxx system variables, which can have different values from the ssl_xxx system variables ...