1、创建用户
CREATE USER 'username'@'host' [IDENTIFIED BY 'PASSWORD'] 其中密码是可选项
CREATE USER 'root'@'192.168.1.%' IDENTIFIED BY '123456';
2、授权
GRANT privileges ON databasename.tablename TO 'username'@'host'
GRANT ALL ON *.* TO 'root'@'192.168.1.%';
3、刷新
flush privileges;