Shulou(Shulou.com)05/31 Report--

This article is about how to configure mysql5.6 to support IPV6 connections in a linux environment. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Brief introduction:

This paper mainly introduces how to configure the connection of mysql to support IPV6 under linux system.

Environmental requirements:

1. Debian7.5 operating system virtual machine

2. The mysql5.6 version of the database, which has been successfully installed on the debian7.5 system, and can be connected normally through the address of IPV4

Configuration method

1. Confirm whether the system supports IPV6, enter the command ping6:: 1, and the following figure shows that the IPV6 address is supported.

2. If not, configure the network card eth0 to add the IPV6 address.

1) enter the command vim / etc/network/interfaces to increase the network card configuration of inet6

2) enter the commands ifdown eth0 and ifup eth0 to restart the Nic to make the configuration effective

3. Configure mysql to allow IPv6 connection

1) modify the my.cnf configuration file, add bind-address =:: configuration under the [mysqld] option, and configure bind-address to:: can guarantee the connection of TCP/IP that supports both IPV4 and IPV6.

2) for users who create IPV6 for the database that can only connect locally, users who use IPV4 log in to the mysql database first

3) execute the command CREATE USER 'ipv6test'@'::1' IDENTIFIED BY' 123456commands; create a user

4) add execution rights to ipv6test users, and execute the command GRANT ALL PRIVILEGES ON *. * TO 'ipv6test'@'::1' IDENTIFIED BY' 123456 'WITH GRANT OPTION

4. Verify that the mysql database is connected locally by:: 1. Enter the command mysql-h:: 1-uipv6test-p123456. The echo below indicates that the connection is successful.

Thank you for reading! This is the end of this article on "how to configure mysql5.6 to support IPV6 connections in linux environment". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it out for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.