Mysql – Specifying MySQL user hosts with IPv6 addresses

Look at the mysql:user table The user is likely enabled only from one host (by name or IP). You can do one of two things:

• Add a second occurrence of the user with access from the second host. (Most secure.)
• Change the host criteria to be less restrictive. (Less secure.)

See the MySQL Access Restrictions documentation for possible less restrictive host specifications.

Your syntax is the good one :

[root@localhost] [(none)] mysql> CREATE USER 'foo'@'2.2.2.2' IDENTIFIED BY 'bar';
Query OK, 0 rows affected (0.00 sec)

You can see if your user is created by using :

[root@localhost] [(none)] mysql> show grants for 'foo'@'2.2.2.2';
+----------------------------------------------------------------------------------------------------------+
| Grants for foo@2.2.2.2                                                                                   |
+----------------------------------------------------------------------------------------------------------+
| GRANT USAGE ON *.* TO 'foo'@'2.2.2.2' IDENTIFIED BY PASSWORD '*E8D46CE25265E545D225A8A6F1BAF642FEBEE5CB' |
+----------------------------------------------------------------------------------------------------------+
1 row in set (0.00 sec)

But it'll work only if you connect from 2.2.2.2.

Max.