Search Results
https://dev.mysql.com/doc/refman/8.4/en/charset-literal.html
For the simple statement SELECT 'string', the string has the connection default character set and collation defined by the character_set_connection and collation_connection system variables. If _charset_name is not specified but COLLATE ... Every ...
https://dev.mysql.com/doc/refman/8.4/en/creating-ssl-files-using-openssl.html
A typical error in this case is: ERROR 2026 (HY000): SSL connection error: error:00000001:lib(0):func(0):reason(1) Important If a client connecting to a MySQL server instance uses an SSL certificate with the extendedKeyUsage extension (an X.509 v3 ... This section describes how to use the openssl command to set up SSL certificate and key files for use by MySQL servers and ...
https://dev.mysql.com/doc/refman/8.4/en/data-directory-initialization.html
If you used --initialize-insecure to initialize the data directory, connect to the server as root without a password: mysql -u root --skip-password After connecting, use an ALTER USER statement to assign a new root password: ALTER USER ... After ...
https://dev.mysql.com/doc/refman/8.4/en/default-privileges.html
If the root account has an empty password, your MySQL installation is unprotected: Anyone can connect to the MySQL server as root without a password and be granted all privileges. Choose whichever of the following procedures applies: If the root ...
https://dev.mysql.com/doc/refman/8.4/en/expired-password-handling.html
For example: ALTER USER 'myuser'@'localhost' PASSWORD EXPIRE; For each connection that uses an account with an expired password, the server either disconnects the client or restricts the client to “sandbox mode,” in which the server permits the ... MySQL provides password-expiration capability, which enables database administrators to require that users reset their ...
https://dev.mysql.com/doc/refman/8.4/en/group-replication-secure-user.html
To secure the user credentials, you can require SSL for connections with the user account, and provide the user credentials when Group Replication is started, rather than storing them in the replica status tables. Important When using the MySQL ...
https://dev.mysql.com/doc/refman/8.4/en/kill.html
KILL [CONNECTION | QUERY] processlist_id Each connection to mysqld runs in a separate thread. The value for the current thread is returned by the CONNECTION_ID() function. KILL permits an optional CONNECTION or QUERY modifier: KILL CONNECTION is ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-config-starting.html
# SQL NODE / API NODE PARAMETERS [mysqld] # HostName=sql-node-A-hostname # NodeId=sql-node-A-nodeid [mysqld] [mysqld] # Each API or SQL node that connects to the cluster requires a [mysqld] # or [api] section of its own. Each such section defines a ...Changes in configuration are also likely to be indicated when changes are made in the platform on which the cluster is run, or in applications that use the NDB Cluster 's ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-log-startup-messages.html
Possible startup messages with descriptions are provided in the following list: Initial start, waiting for %s to connect, nodes [ all: %s connected: %s no-wait: %s ] Waiting until nodes: %s connects, nodes [ all: %s connected: %s no-wait: %s ] ...
https://dev.mysql.com/doc/refman/8.4/en/mysql-cluster-ndbinfo-transporter-details.html
type The connection type used by this transporter (TCP or SHM). This table contains information about individual NDB transporters, rather than aggregate information as shown by the transporters table. sendbuffer_used_bytes The amount, in bytes, of ...