让你的mysql或mariadb 支持ipv6

让你的mysql或mariadb 支持ipv6

如果你在windows 或Linux系统已经安装了mysql/mariadb，并且操作系统本身已经支持了ipv6。

在/etc/my.conf 这样配置可以让mysql也支持ipv6

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
port=13306
bind-address = ::
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
# Settings user and group are ignored when systemd is used.
# If you need to run mysqld under a different user or group,
# customize your systemd unit file for mariadb according to the
# instructions in http://fedoraproject.org/wiki/Systemd

[mysqld_safe]
log-error=/var/log/mariadb/mariadb.log
pid-file=/var/run/mariadb/mariadb.pid

#
# include all files from the config directory
#
!includedir /etc/my.cnf.d

其中，bind-address = :: 就会让你的数据库监听ipv6的请求。

[root@localhost etc]# netstat -an|grep ::
tcp6       0      0 :::13306                :::*                    LISTEN

使用mysql客户端，通过mysql所在server的ipv6地址，就可以访问mysql数据库。

posted @ 2019-03-28 22:32 李欢欢 阅读( ...) 评论( ...) 编辑 收藏