mysql新建用户并分配权限
记录一下
#使用mysql use mysql; #查看所用用户 select * from user ; #创建新用户 CREATE USER 'szhpz'@'%' IDENTIFIED BY 'szhpz@123456'; #删除用户 drop user 'szhpz'@'%'; #赋权 GRANT ALL privileges ON szhpz.* TO 'szhpz'@'%'; #查看权限 SHOW GRANTS FOR 'szhpz'@'%';
记录一下
#使用mysql use mysql; #查看所用用户 select * from user ; #创建新用户 CREATE USER 'szhpz'@'%' IDENTIFIED BY 'szhpz@123456'; #删除用户 drop user 'szhpz'@'%'; #赋权 GRANT ALL privileges ON szhpz.* TO 'szhpz'@'%'; #查看权限 SHOW GRANTS FOR 'szhpz'@'%';