mysql 基本操作

--root用户创建其他用户
CREATE USER 'admin'@'localhost' IDENTIFIED BY 'admin';

--删除用户
Delete FROM user Where User='admin' and Host='host';

--当前用户的授权信息
show grants;

--为用户授权
GRANT ALL PRIVILEGES ON *.* TO 'admin'@'localhost' WITH GRANT OPTION