Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/host-cache-table.html
The host_cache table has these columns: IP The IP address of the client that connected to the server, expressed as a string. While HOST_VALIDATED is NO, DNS resolution is attempted for each connection attempt, until it eventually completes with ...
https://dev.mysql.com/keyring-key-migration.html
A migration server (that is, a server started in key migration mode) does not accept client connections. In this case, the migration server connects to the running server and instructs it to pause keyring operations while key migration is in ... The ...
https://dev.mysql.com/mysqlbinlog-backup.html
mysqlbinlog can read log files directly from the local file system, or, with the --read-from-remote-server option, it can connect to a server and request binary log contents from that server. It can also make a continuous (“live”) backup, ... By ...
https://dev.mysql.com/password-management.html
Dual passwords, to enable clients to connect using either a primary or secondary password. The mysql.user system table indicates for each account when its password was last changed, and the server automatically treats the password as expired at ...
https://dev.mysql.com/charset-applications.html
Applications that use the database should also configure their connection to the server each time they connect. This can be done by executing a SET NAMES 'latin1' statement after connecting. The statement can be used regardless of connection method ... For applications that store data using the default MySQL character set and collation (utf8mb4, utf8mb4_0900_ai_ci), no special configuration should be ...
https://dev.mysql.com/features.html
Support for DELETE, INSERT, REPLACE, and UPDATE to return the number of rows that were changed (affected), or to return the number of rows matched instead by setting a flag when connecting to the server. Password security by encryption of all ...
https://dev.mysql.com/mysql-cluster-programs-ndb-top.html
Usage ndb_top [-h hostname] [-t port] [-u user] [-p pass] [-n node_id] ndb_top connects to a MySQL Server running as an SQL node of the cluster. By default, it attempts to connect to a mysqld running on localhost and port 3306, as the MySQL root ...
https://dev.mysql.com/mysql-shell-tutorial-javascript-shell.html
In most cases, you need an account to connect to the MySQL server instance. After you have installed and started MySQL server, connect MySQL Shell to the server instance. You need to know the address of the MySQL server instance you plan to connect ... This quick-start guide assumes a certain level of familiarity with MySQL ...
https://dev.mysql.com/audit-log-reference.html
Current sessions are no longer logged unless they disconnect and reconnect, or execute a change-user operation. New connections for the user are filtered using the default account filter if there is one, and are not logged otherwise. The filter is ...Unless those components are installed, the audit_log plugin operates in legacy ...
https://dev.mysql.com/group-replication-ip-address-whitelisting.html
The Group Replication plugin has a configuration option to determine from which hosts an incoming Group Communication System connection can be accepted. If you set this option on a server s1, then when server s2 is establishing a connection to s1 ...If you do not specify a whitelist explicitly, the group communication engine (XCom) automatically scans active interfaces on the host, and identifies those with addresses on private ...
Document created the 26/06/2006, last modified the 26/10/2018
Source of the printed document:https://www.gaudry.be/en/mysql-rf-fct-connection-p-12.html
The infobrol is a personal site whose content is my sole responsibility. The text is available under CreativeCommons license (BY-NC-SA). More info on the terms of use and the author.
References
These references and links indicate documents consulted during the writing of this page, or which may provide additional information, but the authors of these sources can not be held responsible for the content of this page.
The author This site is solely responsible for the way in which the various concepts, and the freedoms that are taken with the reference works, are presented here. Remember that you must cross multiple source information to reduce the risk of errors.
