PDF (US Ltr)
- 41.8Mb
PDF (A4)
- 41.9Mb
Man Pages (TGZ)
- 272.4Kb
Man Pages (Zip)
- 378.4Kb
Info (Gzip)
- 4.2Mb
Info (Zip)
- 4.2Mb
Search Results
https://dev.mysql.com/doc/refman/9.7/en/clone-plugin-options-variables.html
A greater number of threads can improve cloning performance but also reduces the number of permitted simultaneous client connections, which can affect the performance of existing client connections. Used to configure an encrypted connection for a ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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/9.7/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/9.7/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/9.7/en/innodb-parameters.html
(In practice, it is most valuable for MySQL systems with hundreds or thousands of simultaneous connections.) For more information, see Section 17.8.4, “Configuring Thread Concurrency for InnoDB”. Each buffer pool instance manages its own free ...
https://dev.mysql.com/doc/refman/9.7/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/9.7/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/9.7/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 ] ...