#指定IP、指定账号、密码访问数据库
mysql> GRANT ALL PRIVILEGES ON *.* TO [username]@"[ip]" IDENTIFIED BY "[password]";
#指定IP、指定账号、密码访问数据库-查询权限
mysql> grant select on 数据库.* to 用户@IP identified by '密码';
#刷新
mysql> flush privileges;
#指定IP、指定账号、密码访问数据库
mysql> GRANT ALL PRIVILEGES ON *.* TO [username]@"[ip]" IDENTIFIED BY "[password]";
#指定IP、指定账号、密码访问数据库-查询权限
mysql> grant select on 数据库.* to 用户@IP identified by '密码';
#刷新
mysql> flush privileges;