PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.5Kb
Man Pages (Zip)
- 401.9Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/query-log.html
The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. Each line that shows when a client connects also includes using connection_type to indicate the protocol used to ...
https://dev.mysql.com/doc/refman/8.0/en/replication-administration-status.html
The SHOW REPLICA STATUS statement, which you must execute on each replica, provides information about the configuration and status of the connection between the replica server and the source server. The replication heartbeat information shown in the ... The most common task when managing a replication process is to ensure that replication is taking place and that there have been no errors between the replica and the ...
https://dev.mysql.com/doc/refman/8.0/en/security-guidelines.html
Anyone using MySQL on a computer connected to the Internet should read this section to avoid the most common security mistakes. MySQL uses security based on Access Control Lists (ACLs) for all connections, queries, and other operations that users ...In discussing security, it is necessary to consider fully protecting the entire server host (not just the MySQL server) against all types of applicable attacks: eavesdropping, altering, playback, and denial of ...
https://dev.mysql.com/doc/refman/8.0/en/server-shutdown.html
If the server tries to create a shutdown thread and cannot (for example, if memory is exhausted), it issues a diagnostic message that appears in the error log: Error: Can't create thread to kill server The server stops accepting new connections. To ... The server shutdown process takes place as follows: The shutdown process is ...
https://dev.mysql.com/doc/refman/8.0/en/show-processlist.html
The SHOW PROCESSLIST statement is very useful if you get the “too many connections” error message and want to find out what is going on. MySQL reserves one extra connection to be used by accounts that have the CONNECTION_ADMIN privilege (or the ... SHOW [FULL] PROCESSLIST Important The INFORMATION SCHEMA implementation of SHOW PROCESSLIST is deprecated and subject to removal in a future MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/windows-server-first-start.html
They can use TCP/IP, or they can use a named pipe if the server supports named-pipe connections. MySQL for Windows also supports shared-memory connections if the server is started with the shared_memory system variable enabled. Clients can connect ... This section gives a general overview of starting the MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/alter-instance.html
For additional information about reconfiguring the TLS context, including which system and status variables are context-related, see Server-Side Runtime Configuration and Monitoring for Encrypted Connections. By default, the statement reloads the ...
https://dev.mysql.com/doc/refman/8.0/en/charset-introducer.html
Escapes are always interpreted by the parser according to the character set given by character_set_connection. If _charset_name is not specified but COLLATE collation_name is specified: For a character string literal, the connection default ... A ...
https://dev.mysql.com/doc/refman/8.0/en/clone.html
Connecting to the donor MySQL server instance through MySQL Router is also not supported.) IDENTIFIED BY 'password' specifies the password of the clone user on the donor MySQL server instance. [REQUIRE [NO] SSL] explicitly specifies whether an ...
https://dev.mysql.com/doc/refman/8.0/en/creating-ssl-rsa-files-using-mysql.html
MySQL provides these ways to create the SSL certificate and key files and RSA key-pair files required to support encrypted connections using SSL and secure password exchange using RSA over unencrypted connections, if those files are missing: The ...