mysql_variables - Manage MySQL global variables
New in version 1.3.
Synopsis
-
- 查询/设置MySQL变量
Options
parameter | required | default | choices | comments | |
---|---|---|---|---|---|
config_file
(added in 2.0)
| no | ~/.my.cnf |
指定要从中读取用户和密码的配置文件。
| ||
connect_timeout
(added in 2.1)
| no | 30 |
连接到MySQL服务器时的连接超时。
| ||
login_host | no | localhost |
运行数据库的主机
| ||
login_password | no |
The password used to authenticate with.
| |||
login_port | no | 3306 |
MySQL服务器端口。如果使用login_port,则需要将
login_host
定义为其他本地主机。
| ||
login_unix_socket | no |
到本地连接的Unix域套接字的路径。
| |||
login_user | no |
The username used to authenticate with.
| |||
ssl_ca
(added in 2.0)
| no |
| |||
ssl_cert
(added in 2.0)
| no |
The path to a client public key certificate.
| |||
ssl_key
(added in 2.0)
| no |
The path to the client private key.
| |||
value | no |
如果设置,则将变量值设置为此
| |||
variable | yes |
Variable name to operate
|