insert into mysql.user (user,host,password) values('jiangjianyi','%',password('jiangjianyi'));
CREATE USER 'jiangjianyi'@'%' IDENTIFIED BY 'jiangjianyi';
flush privileges;
CREATE USER 'jiangjianyi'@'%' IDENTIFIED BY "123";
grant all on user.address to 'jiangjianyi'@'%'
GRANT SELECT,INSERT,DELETE,UPDATE,CREATE,INDEX ON *.* TO 'jiangjianyi'@'%' IDENTIFIED BY 'jiangjianyi' WITH GRANT OPTION;
UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='jiangjianyi';
FLUSH PRIVILEGES;
grant select,insert,update,create,drop,delete on sss.* to sss@'%' identified by 'sss';
grant all privileges on pixelfed.* to 'pixelfed'@'%' identified by 'strong_password';
flush privileges;
Mysql创建用户
最新推荐文章于 2023-06-24 10:30:34 发布