登录:
mysql -h localhost -u root -p;
创建用户:
CREATE USER user01@'localhost' IDENTIFIED BY 'password1';(只能本地访问)
CREATE USER user02@'%' IDENTIFIED BY 'password1';(可以远程访问)
修改用户密码:
SET PASSWORD FOR 'user01'@'localhost' = PASSWORD('password2');
创建数据库:
create database db01;
授权:
GRANT ALL PRIVILEGES ON db01.* TO user01;(user01管理db01全部权限)
revoke all on *.* from 'user01' @'%';(收回user01全部权限)
删除数据库:
drop database db01;