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;

转载于:https://www.cnblogs.com/higreen/p/9928592.html