- mariadb新建用户
# 用户@ip,%表示所有
create user 'xvnmeng'@'%' identified by 'xvnmeng';
# 全部权限
GRANT ALL PRIVILEGES ON *.* TO 'xvnmeng'@'%' IDENTIFIED BY 'xvnmeng' WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;
# 如果有报错,需要赋值localhost进入
# 用户@ip,%表示所有
create user 'xvnmeng'@'%' identified by 'xvnmeng';
# 全部权限
GRANT ALL PRIVILEGES ON *.* TO 'xvnmeng'@'%' IDENTIFIED BY 'xvnmeng' WITH GRANT OPTION;
# 刷新
FLUSH PRIVILEGES;
# 如果有报错,需要赋值localhost进入