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'@'%';