Search Results
https://dev.mysql.com/doc/refman/8.4/en/time-zone-support.html
Time Zone Variables Populating the Time Zone Tables Staying Current with Time Zone Changes Time Zone Leap Second Support Time Zone Variables MySQL Server maintains several time zone settings: The server system time zone. When the server starts, it ... This section describes the time zone settings maintained by MySQL, how to load the system tables required for named time support, how to stay current with time zone changes, and how to enable leap-second ...
https://dev.mysql.com/doc/refman/8.4/en/connecting.html
For a client program to connect to the MySQL server, it must use the proper connection parameters, such as the name of the host where the server is running and the user name and password of your MySQL account. Client programs determine what type of ... This section describes use of command-line options to specify how to establish connections to the MySQL server, for clients such as mysql or ...
https://dev.mysql.com/doc/refman/8.4/en/multiple-servers.html
Or you might want to give different users access to different mysqld servers that they manage themselves. (For example, you might be an Internet Service Provider that wants to provide independent MySQL installations for different customers.) It is ... In some cases, you might want to run multiple instances of MySQL on a single ...
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/connecting-using-dns-srv.html
A DNS lookup on the name returns a reply containing the names of multiple available servers in the domain that provide the required service. For information about DNS SRV, including how a record defines the preference order of the listed servers, ...
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/multiple-windows-command-line-servers.html
The procedure for starting a single MySQL server manually from the command line is described in Section 2.3.3.6, “Starting MySQL from the Windows Command Line”. To start multiple servers this way, you can specify the appropriate options on the ...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/windows-troubleshooting.html
The default data directory location is C:\Program Files\MySQL\MySQL Server 8.4\data, or C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. Fatal error: Can't open and lock privilege tables: Table 'mysql.user' doesn't exist These messages ...
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/mysql-installer/en/server-type-network.html
Server Configuration Type Choose the MySQL server configuration type that describes your setup. This setting defines the amount of system resources (memory) to assign to your MySQL server instance. Server: Several other applications are expected to ...Development: A computer that hosts many other applications, and typically this is your personal ...