这是一个类似于如何为整个子网授予MySQL远程访问权限?的问题,但它涉及到IPv6子网。根据https://dev.mysql.com/doc/refman/5.5/en/account-names.html,host_ip/netmask格式在IPv6中不被允许。那么,我该如何允许来自我的IPv6子网的连接?
CREATE USER 'newuser'@'2001:DB8:100:feed::%' IDENTIFIED BY 'thepassword';
然后我授权该用户访问相关的数据库:GRANT ALL PRIVILEGES ON crowd.* to 'crowduser'@'2603:3026:100:13e1:%' WITH GRANT OPTION