需求
1芙贫、創(chuàng)建非root用戶只能訪問某固定database
2、只允許某IP訪問
創(chuàng)建非root用戶
創(chuàng)建用戶名username的用戶，可以任意IP登錄蛾默，密碼為password
CREATE USER 'username'@'%' IDENTIFIED BY 'password';
創(chuàng)建用戶名username的用戶捷绒，固定IP登錄瑰排，密碼為password
CREATE USER 'username'@'192.168.1.91' IDENTIFIED BY 'password';
創(chuàng)建用戶名username的用戶，IP段登錄暖侨，密碼為password
CREATE USER 'username'@'192.168.1.%' IDENTIFIED BY 'password';
給予權(quán)限
給予username訪問database名是db_dev的所有表增刪改查權(quán)限椭住，限制IP段。
grant all privileges on db_dev.* to 'username'@'192.168.1.%' identified by 'password' with grant option;
