Linux下给mysql创建用户分配权限

//登录MYSQL
mysql -u root -p
//创建用户：
CREATE USER 'hahha'@'%' IDENTIFIED BY '123456';
//刷新系统权限表
flush privileges;
//针对每个表分配权限：
grant select,UPDATE,INSERT ON biaoju.bj_baobiao_member to wangxiao@'%';
grant select,UPDATE,INSERT ON biaoju.bj_person to wangxiao@'%';

//分配fe表的所有权限：
grant all privileges on fe.* to hahha@'%';
//分配所有表的所有权限：

grant all privileges on *.* to hahha@'%';

分配完以后需要刷新系统权限表

grant create,alter,drop,select,insert,update,delete on lhyg_api.ly_person_order to lyk@'%';


mysqlgrant create,alter,drop,select,insert,update,delete on lhyg_api.ly_person_order to lyk@'120.1.16.252';



SET PASSWORD FOR lyk@'120.1.16.252' = PASSWORD('lyk123456');



CREATE USER 'lyk'@'%' IDENTIFIED BY 'lyk123456';

grant select on lhyg.ly_person_order to lyk@'%';
grant select on lhyg.ly_class to lyk@'%';
grant select on lhyg.ly_person_status to lyk@'%';
grant select,update on lhyg.ly_job to lyk@'%';

grant select,UPDATE,insert on lhygv3.ly_group_history to lyk@'%';
grant select,UPDATE,insert on lhygv3.ly_group_member to lyk@'%';
grant select,UPDATE,insert on lhygv3.ly_group_member_history to lyk@'%';
grant select,UPDATE,insert on lhygv3.ly_group_qrcode to lyk@'%';
grant select,UPDATE,insert on lhygv3.ly_group to lyk@'%';
grant select,UPDATE on lhygv3.ly_person_info to lyk@'%';
--------------------------------------------------------------------------------------------------------------------------------
grant select on lgbv3.ly_person_order to lyk@'%';
grant select ON lgbv3.ly_class to lyk@'%';
grant select,update ON lgbv3.ly_job to lyk@'%';
grant select,UPDATE,insert on lgbv3.ly_group_history to lyk@'%';
grant select,UPDATE,insert on lgbv3.ly_group_member to lyk@'%';
grant select,UPDATE,insert on lgbv3.ly_group_member_history to lyk@'%';
grant select,UPDATE,insert on lgbv3.ly_group_qrcode to lyk@'%';
grant select,UPDATE,insert on lgbv3.ly_group to lyk@'%';
grant select,UPDATE on lgbv3.ly_person_info to lyk@'%';


grant select,UPDATE,INSERT,delete ON lgbv3.ly_contract_user to lyf@'%';
grant select,UPDATE,INSERT,delete ON lgbv3.ly_customer to lyf@'%';
grant select,UPDATE,INSERT,delete ON lgbv3.ly_customer_partner to lyf@'%';
grant select,UPDATE,INSERT,delete ON lgbv3.ly_customer_sign to lyf@'%';
grant select,UPDATE,INSERT,delete ON lgbv3.ly_partnertask to lyf@'%';
grant select,UPDATE,INSERT,delete ON lgbv3.ly_user_customer_mapper to lyf@'%';