创建用户: CREATE USER 'user1'@'192.168.1.%' IDENTIFIED BY '123456'; 修改权限: grant ALTER ON `test`.* TO 'root'@'192.168.123.%';