mysql 命令

#修改密码

alter user 'User'@'Host' identified by '新密码';

#创建账号

CREATE USER 'app'@'localhost' IDENTIFIED BY 'app';
Grant all privileges ON 数据库.* to 'app'@'localhost';

#解除账号锁

alter user 'User'@'Host' account unlock;

posted @ 2018-11-08 13:46  绿静風  阅读(97)  评论(0编辑  收藏  举报