Rechercher dans le manuel MySQL
Search Results
https://dev.mysql.com/replication-problems.html
If the slave is running, check whether it established a connection to the master. If the I/O thread state says Connecting to master, check the following: Verify the privileges for the user being used for replication on the master. Check that the ...
https://dev.mysql.com/request-access.html
After you establish a connection, the server enters Stage 2 of access control. For each request that you issue through that connection, the server determines what operation you want to perform, then checks whether you have sufficient privileges to ...This is where the privilege columns in the grant tables come into ...
https://dev.mysql.com/reserved-users.html
This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. This account is locked so that it cannot be used for client connections. One part of the MySQL ...
https://dev.mysql.com/restart.html
Note After executing a RESTART statement, the client can expect the current connection to be lost. If auto-reconnect is enabled, the connection will be reestablished after the server restarts. One use for RESTART is when it is not possible or ...
https://dev.mysql.com/stage-summary-tables.html
For summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each stage summary table that is ... The ...
https://dev.mysql.com/statement-summary-tables.html
For other summary tables aggregated by account, host, or user, truncation removes rows for accounts, hosts, or users with no connections, and resets the summary columns to zero for the remaining rows. In addition, each statement summary table that ... The Performance Schema maintains tables for collecting current and recent statement events, and aggregates that information in summary ...
https://dev.mysql.com/string-functions-charset.html
For operations that convert to character data, the character set and collation of the strings that result from the operations are defined by the character_set_connection and collation_connection system variables that determine the default connection ... MySQL has many operators and functions that return a ...
https://dev.mysql.com/system-variable-privileges.html
In addition, you must connect to the server using an encrypted connection and supply an SSL certificate with the Subject value specified by the persist_only_admin_x509_subject system variable. For persist-restricted variables, RESET PERSIST does not ...(For information about dynamic variables, see Section 5.1.9.2, “Dynamic System Variables”.) For certain global system variables, SET can be used to persist their value to the mysqld-auto.cnf file in the data directory, to affect server operation for subsequent ...
https://dev.mysql.com/time-zone-support.html
Each client that connects has its own session time zone setting, given by the session time_zone variable. For example: mysql_tzinfo_to_sql /usr/share/zoneinfo | mysql -u root -p mysql The mysql command shown here assumes that you connect to the ...
https://dev.mysql.com/tp-thread-group-state-table.html
CONNECT_THREAD_COUNT The number of threads that are processing or waiting to process connection initialization and authentication. There can be a maximum of four connection threads per thread group; these threads expire after a period of inactivity.
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-37.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.
