准备:lnmp环境
查看数据库下的所有表:
select user,authentication_string,host from mysql.user;
给予权限给指定网段
grant all privileges on bbs.* to bbs@'172.16.1.%'identified by 'keyan123';
select user,authentication_string,host from mysql.user;
grant all privileges on bbs.* to bbs@'172.16.1.%'identified by 'keyan123';