mysql 添加用户

-- 创建用户
CREATE USER 'user1'@'%' IDENTIFIED BY 'user1mysql123';

-- 赋予远程连接权限
GRANT USAGE ON *.* TO 'user1'@'%';

-- 拒绝对其他表的权限
REVOKE ALL PRIVILEGES ON *.* FROM 'user1'@'%';

-- 赋予对指定表的只读权限
GRANT SELECT ON community.zero1_1664258495600 TO 'user1'@'%';
GRANT SELECT ON community.zero1_1664259327961 TO 'user1'@'%';
GRANT SELECT ON community.zzr_1664261224680 TO 'user1'@'%';
GRANT SELECT ON community.zzr_1664261276234 TO 'user1'@'%';

-- 刷新权限
FLUSH PRIVILEGES;

select user,host from mysql.user;

GRANT SELECT, INSERT, UPDATE, DELETE ON meta_house_resident TO 'merger'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON meta_ledger_task TO 'merger'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON meta_ledger_detail TO 'merger'@'%';
GRANT SELECT, INSERT, UPDATE, DELETE ON meta_ledger_dispatch TO 'merger'@'%';
FLUSH PRIVILEGES;

show GRANTS for 'merger'@'%';