Search Results
https://dev.mysql.com/doc/refman/8.4/en/set-names.html
SET NAMES {'charset_name' [COLLATE 'collation_name'] | DEFAULT} This statement sets the three session system variables character_set_client, character_set_connection, and character_set_results to the given character set. Setting ...The optional ...
https://dev.mysql.com/doc/refman/8.4/en/set-role.html
When a user connects to the server and authenticates successfully, the server determines which roles to activate as the default roles. SET ROLE { DEFAULT | NONE | ALL | ALL EXCEPT role [, role ] ... } SET ROLE modifies the current user's effective ...
https://dev.mysql.com/doc/refman/8.4/en/set-statement.html
SET CHARACTER SET and SET NAMES assign values to character set and collation variables associated with the current connection to the server. Descriptions for those forms that are not associated with a specific server capability appear in subsections ...
https://dev.mysql.com/doc/refman/8.4/en/set-variable.html
However, the change affects the corresponding session value only for clients that connect after the change. qualifier: SET PERSIST max_connections = 1000; SET @@PERSIST.max_connections = 1000; This SET syntax enables you to make configuration ...
https://dev.mysql.com/doc/refman/8.4/en/show-grants.html
SHOW GRANTS [FOR user_or_role [USING role [, role] ...]] user_or_role: { user (see Section 8.2.4, “Specifying Account Names”) | role (see Section 8.2.5, “Specifying Role Names”. } This statement displays the privileges and roles that are ...
https://dev.mysql.com/doc/refman/8.4/en/show-replicas.html
SHOW REPLICAS Displays a list of replicas currently registered with the source. SHOW REPLICAS should be executed on a server that acts as a replication source. Host: The host name of the replica server, as specified on the replica with the ...
https://dev.mysql.com/doc/refman/8.4/en/shutdown.html
SIGTERM enables server shutdown to be performed without having to connect to the server. SHUTDOWN provides an SQL-level interface to the same functionality available using the mysqladmin shutdown command. A successful SHUTDOWN sequence consists of ...
https://dev.mysql.com/doc/refman/8.4/en/solaris-installation.html
If too many processes try to connect very rapidly to mysqld, you should see this error in the MySQL log: Error in accept: Protocol error You might try starting the server with the --back_log=50 option as a workaround for this. Note MySQL 8.4 ...
https://dev.mysql.com/doc/refman/8.4/en/source-installation-prerequisites.html
An SSL library is required for support of encrypted connections, entropy for random number generation, and other encryption-related operations. Some of these tools are needed no matter whether you use a standard source distribution or a development ...
https://dev.mysql.com/doc/refman/8.4/en/source-thread-states.html
If you see no Binlog Dump threads on a source, this means that replication is not running; that is, that no replicas are currently connected. The following list shows the most common states you may see in the State column for the Binlog Dump thread ...