mysql 添加用户+授权+刷新权限
2022-03-24 本文已影响0人
不要可惜
# 创建用户
CREATE USER 'someuser' @'%' IDENTIFIED BY 'password';
# 授权
GRANT privileges someuser ON somedatabase.* TO 'someuser' @'%'
# 刷新
flush privileges;
# 创建用户
CREATE USER 'someuser' @'%' IDENTIFIED BY 'password';
# 授权
GRANT privileges someuser ON somedatabase.* TO 'someuser' @'%'
# 刷新
flush privileges;