--mysql用户管理本质是对mysql数据库的user表增删改查
--新增用户,不带@localhost的话,默认没有密码,即使设置了'123456'
CREATE USER kuang2 IDENTIFIED BY '123456'
CREATE USER kuang2@localhost IDENTIFIED BY '123456'
--授所有的权限
GRANT ALL PRIVILEGES on *.* to kuang2@localhost
--查看表结构
DESCRIBE mysql.user
select * FROM mysql.user
GRANT ALL PRIVILEGES on *.* to kuang2
--更改用户密码
set password for kuang =PASSWORD('123')
--查看用户权限
show GRANTS for 'kuang2'
use mysql;
select * from user where user='kuang2';
--刷新权限
flush privileges;
参考文献: