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”.


数据运维技术 » MySQL Variables skip_networking 数据库 参数变量解释及正确配置使用