Search Results
https://dev.mysql.com/doc/refman/8.4/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.4/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.4/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.4/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.4/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/c-api/8.4/en/c-api-optional-metadata.html
Clients can indicate on a per-connection basis that result set metadata is optional and that the client will indicate to the server whether to return it. There are two ways for a client to indicate that result set metadata is optional for a ... When ...
https://dev.mysql.com/doc/c-api/8.4/en/mysql-ping.html
int mysql_ping(MYSQL *mysql) Description Checks whether the connection to the server is working. If the connection has gone down and auto-reconnect is enabled an attempt to reconnect is made. If the connection is down and auto-reconnect is ...
https://dev.mysql.com/doc/relnotes/mysql-shell/8.4/en/news-8-4-3.html
(Bug #36701854) Running any of the diagnostics utilities against an instance with binary logging disabled, and using an X Protocol connection, resulted in an error. As of this release, the diagnostics utilities use classic connections, only. If the ... AdminAPI Bugs Fixed Utilities Added or Changed Functionality Utilities Bugs Fixed Bugs Fixed AdminAPI Bugs Fixed Running a rescan() operation on a Replica Cluster, could result in a warning that group_replication_view_change_uuid is required, but not ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-8-0-17.html
Version 8.0.17 is the latest General Availability release of the 8.0 series of MySQL Connector/J. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. (WL #12247) The README and LICENSE files are now included ...
https://dev.mysql.com/doc/relnotes/connector-j/en/news-9-1-0.html
Version 9.1.0 is a new GA release of MySQL Connector/J. MySQL Connector/J 9.1.0 supersedes 9.0 and is recommended for use on production systems. It supports the Java Database Connectivity (JDBC) 4.2 API, and implements the X DevAPI. Functionality ...This release can be used against MySQL Server version 8.0 and ...