Search Results
https://dev.mysql.com/doc/refman/8.4/en/kerberos-pluggable-authentication.html
This SPN must be registered in the Kerberos system, and is configured on the server side using the authentication_kerberos_service_principal system variable. To be usable by the server, the plugin library file must be located in the MySQL plugin ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
Alternatively, if the host has multiple network addresses, you can set the bind_address system variable to cause each server to listen to a different address. As discussed in the following sections, it is possible to start additional servers by ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-windows-command-line-servers.html
Enable such connections by starting the server with the shared_memory system variable enabled and specify a unique shared-memory name for each server by setting the shared_memory_base_name system variable. The procedure for starting a single MySQL ...Suppose that you want to run one instance of mysqld on port 3307 with a data directory of C:\mydata1, and another instance on port 3308 with a data directory of ...
https://dev.mysql.com/doc/refman/8.4/en/connecting-using-dns-srv.html
In the Domain Name System (DNS), a SRV record (service location record) is a type of resource record that enables a client to specify a name that indicates a service, protocol, and domain. A DNS lookup on the name returns a reply containing the ...
https://dev.mysql.com/doc/refman/8.4/en/faqs-sql-modes.html
What is the default server SQL mode when MySQL 8.4 is installed? A.3.1. What are server SQL modes? Server SQL modes define what SQL syntax MySQL should support and what kind of data validation checks it should perform. This makes it easier to use ...
https://dev.mysql.com/doc/refman/8.4/en/windows-troubleshooting.html
The following examples show other common error messages you might encounter when installing MySQL and starting the server for the first time: If the MySQL server cannot find the mysql privileges database or other critical files, it displays these ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-mysqld.html
(For information about mysqld options and variables, in addition to those discussed in this section, which are relevant to NDB Cluster, see Section 25.4.3.9, “MySQL Server Options and Variables for NDB Cluster”.) If the mysqld binary has been ...
https://dev.mysql.com/doc/refman/8.4/en/version-tokens-usage.html
Client applications register a list of version tokens they require the server to match by setting a system variable. The client connects to server 2 and registers its server requirements there by setting its version_tokens_session system variable: ...A scenario in which Version Tokens can be useful is a system that accesses a collection of MySQL servers but needs to manage them for load balancing purposes by monitoring them and adjusting server assignments according to load ...
https://dev.mysql.com/doc/mysql-installer/en/server-type-network.html
This setting defines the amount of system resources (memory) to assign to your MySQL server instance. Manual Prevents MySQL Installer from attempting to optimize the server installation, and instead, sets the default values to the server variables ... Server Configuration Type Choose the MySQL server configuration type that describes your ...Development: ...