一、创建只读账号
CREATE USER 'readeuser'@'localhost' IDENTIFIED BY 'readeuser';
GRANT Select ON *.* TO reader@"%" IDENTIFIED BY "readeuser"
%如果替换成ip,则为只有对应的ip可以连接
二、创建增删改查账号
CREATE USER 'readeuser'@'localhost' IDENTIFIED BY 'readeuser';
GRANT Select,Update,insert,delete ON *.* TO writer@"%" IDENTIFIED BY "readeuser"
%如果替换成ip,则为只有对应的ip可以连接
drop user xxx@"%"
drop user xxx@"%"
"%"表示任意非本地机器