MySQL Variables skip_networking 数据库 参数变量解释及正确配置使用
本站中文解释
skip_networking参数用于禁用远程连接MySQL服务器,需要在MySQL的配置文件中进行设置。
设置:
1.在MySQL的配置文件中加上skip_networking参数,一般如下:
skip_networking
2.保存并关闭MySQL的配置文件。
3.重新启动MySQL服务,即可实现禁用远程连接MySQL服务器。
官方英文解释
skip_networking
Command-Line Format | --skip-networking[={OFF|ON}] |
---|---|
System Variable | skip_networking |
Scope | Global |
Dynamic | No |
Type | Boolean |
Default Value | OFF |
This variable controls whether the server permits TCP/IP
connections. By default, it is disabled (permit TCP
connections). If enabled, the server permits only local
(non-TCP/IP) connections and all interaction with
mysqld must be made using named pipes or
shared memory (on Windows) or Unix socket files (on Unix).
This option is highly recommended for systems where only local
clients are permitted. See Section 5.1.11.2, “DNS Lookups and the Host Cache”.