https://dev.mysql.com/mysqlbinlog.html
To read remote binary logs, the connection parameter options can be given to indicate how to connect to the server. --bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for ...
https://dev.mysql.com/server-status-variables.html
The optional GLOBAL keyword aggregates the values over all connections, and SESSION shows the values for the current connection. mysql> SHOW GLOBAL STATUS; +-----------------------------------+------------+ | Variable_name | Value | ... The MySQL ...
https://dev.mysql.com/mysqladmin.html
To kill threads belonging to other users, the connected user must have the CONNECTION_ADMIN or SUPER privilege. This changes the password to new_password for the account that you use with mysqladmin for connecting to the server. This is true even if ...You can use it to check the server's configuration and current status, to create and drop databases, and ...
https://dev.mysql.com/mysql-options.html
int mysql_options(MYSQL *mysql, enum mysql_option option, const void *arg) Can be used to set extra connect options and affect behavior for a connection. Options for information such as SSL certificate and key files are used to establish an ...This ...
https://dev.mysql.com/mysqlslap.html
--detach=N Detach (close and reopen) each connection after each N statements. This option applies to clients that connect to the server using an account that authenticates with the caching_sha2_password authentication plugin. For connections by such ... mysqlslap is a diagnostic program designed to emulate client load for a MySQL server and to report the timing of each ...
https://dev.mysql.com/mysql-upgrade.html
If you have multiple MySQL server instances to upgrade, invoke mysql_upgrade with connection parameters appropriate for connecting to each of the desired servers. --bind-address=ip_address On a computer having multiple network interfaces, use this ... Note As of MySQL 8.0.16, the MySQL server performs the upgrade tasks previously handled by mysql_upgrade (for details, see Section 2.11.3, “What the MySQL Upgrade Process ...
https://dev.mysql.com/mysqldump.html
Note A dump made using PowerShell on Windows with output redirection creates a file that has UTF-16 encoding: shell> mysqldump [options] > dump.sql However, UTF-16 is not permitted as a connection character set (see Impermissible Client Character ...
https://dev.mysql.com/mysql-cluster-options-variables.html
Each connection requires its own [api] or [mysqld] section in the cluster configuration (config.ini) file, and counts against the maximum number of API connections supported by the cluster. Suppose that you have 2 cluster host computers, each ...
https://dev.mysql.com/mysql-innodb-cluster-working-with-cluster.html
Instances which do not support persisting configuration changes automatically (see Persisting Settings) require you to connect to the server, run MySQL Shell, connect to the instance locally and issue dba.configureLocalInstance(). The recommended ...
https://dev.mysql.com/mysqlshow.html
--bind-address=ip_address On a computer having multiple network interfaces, use this option to select which interface to use for connecting to the MySQL server. This option applies to clients that connect to the server using an account that ... The ...
