PDF (US Ltr)
- 43.3Mb
PDF (A4)
- 43.4Mb
Man Pages (TGZ)
- 296.6Kb
Man Pages (Zip)
- 402.0Kb
Info (Gzip)
- 4.3Mb
Info (Zip)
- 4.3Mb
Search Results
https://dev.mysql.com/doc/refman/8.0/en/starting-server-troubleshooting.html
If you do not get an error message like telnet: Unable to connect to remote host: Connection refused, some other program is using the TCP/IP port that mysqld is trying to use. In this case, specify the same non-default port number for client ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-disable-thread.html
Given a connection ID, disables Performance Schema instrumentation for the thread. Example Disable a specific connection by its connection ID: mysql> CALL sys.ps_setup_disable_thread(225); +-------------------+ | summary | +-------------------+ | ...This is a value of the type given in the PROCESSLIST_ID column of the Performance Schema threads table or the Id column of SHOW PROCESSLIST ...
https://dev.mysql.com/doc/refman/8.0/en/sys-ps-setup-enable-thread.html
Given a connection ID, enables Performance Schema instrumentation for the thread. Example Enable a specific connection by its connection ID: mysql> CALL sys.ps_setup_enable_thread(225); +------------------+ | summary | +------------------+ | ...
https://dev.mysql.com/doc/refman/8.0/en/sys-session-ssl-status.html
For each connection, this view displays the SSL version, cipher, and count of reused SSL sessions. The session_ssl_status view has these columns: thread_id The thread ID for the connection.
https://dev.mysql.com/doc/refman/8.0/en/thread-commands.html
Connect Used by replication receiver threads connected to the source, and by replication worker threads. Daemon This thread is internal to the server, not a thread that services a client connection. A thread can have any of the following Command ...
https://dev.mysql.com/doc/refman/8.0/en/windows-testing.html
(Be sure that an account exists that specifies an IP address or you may not be able to connect.) You can force a MySQL client to use a named-pipe connection rather than TCP/IP by specifying the --pipe or --protocol=PIPE option, or by specifying . If ...In this case, start mysqld with the skip_name_resolve system variable enabled and use only localhost and IP addresses in the Host column of the MySQL grant ...
https://dev.mysql.com/doc/refman/8.0/en/account-categories.html
To kill a session or statement that is executing with the SYSTEM_USER privilege, your own session must have the SYSTEM_USER privilege, in addition to any other required privilege (CONNECTION_ADMIN or the deprecated SUPER privilege). From MySQL ...
https://dev.mysql.com/doc/refman/8.0/en/audit-log-file-reading.html
For example: [ { "timestamp": "2020-05-18 13:39:33", "id": 0, "class": "connection", "event": "connect", ... }, { "timestamp": "2020-05-18 13:39:33", "id": 2, "class": "connection", "event": "disconnect", ... The audit log plugin supports functions ...
https://dev.mysql.com/doc/refman/8.0/en/cleartext-pluggable-authentication.html
To avoid problems if there is any possibility that the password would be intercepted, clients should connect to MySQL Server using a method that protects the password. Possibilities include SSL (see Section 8.3, “Using Encrypted Connections”), ... A client-side authentication plugin is available that enables clients to send passwords to the server as cleartext, without hashing or ...
https://dev.mysql.com/doc/refman/8.0/en/clone-plugin-encrypted-data.html
The following requirements apply: A secure connection is required when cloning remote data to ensure safe transfer of unencrypted tablespace keys over the network. An error is reported if an encrypted connection is not available or the REQUIRE NO ...