MySQL Variables named_pipe_full_access_group 数据库 参数变量解释及正确配置使用
  iDU31ygkXmx7 2023年11月20日 48 0

本站中文解释

named_pipe_full_access_group是MySQL参数变量,用于指定一个Windows组,该组中的所有成员都可以读取和写入MySQL服务器上使用命名管道进行文件通信的文件。

要设置此参数,请打开MySQL服务端的my.ini配置文件,找到[mysqld]部分,添加一行:named_pipe_full_access_group=,Windows group name为要设置的Windows组的完整名称(包括完整的路径)。
用完之后,保存my.ini文件,然后重新启动MySQL服务,使更改生效。

官方英文解释

named_pipe_full_access_group

Command-Line Format --named-pipe-full-access-group=value
Introduced 5.7.25
System Variable named_pipe_full_access_group
Scope Global
Dynamic No
Platform Specific Windows
Type String
Default Value empty string
Valid Values

empty string

valid Windows local group name

*everyone*

(Windows only.) The access control granted to clients on the
named pipe created by the MySQL server is set to the minimum
necessary for successful communication when the
named_pipe system variable is
enabled to support named-pipe connections. Some MySQL client
software can open named pipe connections without any
additional configuration; however, other client software may
still require full access to open a named pipe connection.

This variable sets the name of a Windows local group whose
members are granted sufficient access by the MySQL server to
use named-pipe clients. As of MySQL 5.7.34, the default value
is set to an empty string, which means that no Windows user is
granted full access to the named pipe.

A new Windows local group name (for example,
mysql_access_client_users) can be created
in Windows and then used to replace the default value when
access is absolutely necessary. In this case, limit the
membership of the group to as few users as possible, removing
users from the group when their client software is upgraded. A
non-member of the group who attempts to open a connection to
MySQL with the affected named-pipe client is denied access
until a Windows administrator adds the user to the group.
Newly added users must log out and log in again to join the
group (required by Windows).

Setting the value to '*everyone*' provides
a language-independent way of referring to the Everyone group
on Windows. The Everyone group is not secure by default.

【版权声明】本文内容来自摩杜云社区用户原创、第三方投稿、转载,内容版权归原作者所有。本网站的目的在于传递更多信息,不拥有版权,亦不承担相应法律责任。如果您发现本社区中有涉嫌抄袭的内容,欢迎发送邮件进行举报,并提供相关证据,一经查实,本社区将立刻删除涉嫌侵权内容,举报邮箱: cloudbbs@moduyun.com

  1. 分享:
最后一次编辑于 2023年11月20日 0

暂无评论

iDU31ygkXmx7