Movatterモバイル変換

Start the MySQL server with an appropriatebind_address setting to permit it to accept IPv6 connections. For example, put the following lines in the server option file and restart the server:

[mysqld]bind_address = *

Alternatively, you can bind the server to::1, but that makes the server more restrictive for TCP/IP connections. It accepts only IPv6 connections for that single address and rejects IPv4 connections. For more information, see thebind_address description inSection 5.1.7, “Server System Variables”.

As an administrator, connect to the server and create an account for a local user who connects from the::1 local IPv6 host address:

mysql> CREATE USER 'ipv6user'@'::1' IDENTIFIED BY 'ipv6pass';

For the permitted syntax of IPv6 addresses in account names, seeSection 6.2.4, “Specifying Account Names”. In addition to theCREATE USER statement, you can issueGRANT statements that give specific privileges to the account, although that is not necessary for the remaining steps in this procedure.

Invoke themysql client to connect to the server using the new account:

$> mysql -h ::1 -u ipv6user -pipv6pass

Try some simple statements that show connection information:

mysql> STATUS...Connection:   ::1 via TCP/IP...mysql> SELECT CURRENT_USER(), @@bind_address;+----------------+----------------+| CURRENT_USER() | @@bind_address |+----------------+----------------+| ipv6user@::1   | ::             |+----------------+----------------+