MySql 帐户管理常用命令(主要是针对 MySql8,其它版本可能会有所差异)
# 删除帐号(如果存在的话)
DROP USER IF EXISTS 'root'@'localhost';
# 创建帐户
CREATE USER 'root'@'localhost' IDENTIFIED BY '12345678'; # MySql8 新的密码加密方式
CREATE USER 'root'@'localhost' WITH mysql_native_password BY '12345678'; # 老版本加密方式,有部分客户端还不支持新的加密方式,因此保留这种兼容
# 撤消所有权限
REVOKE all privileges ON *.* FROM 'root'@'localhost';
# 给予权限
GRANT select, insert, update, delete ON *.* TO 'root'@'localhost'; # 给予部分权限
GRANT all privileges ON *.* TO 'root'@'localhost' with grant option; # 给予全部权限
# 改密码
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '12345678';