mysql 8.0 用户操作

#创建用户：
CREATE USER foobared IDENTIFIED BY 'foobared';
#置空密码：
update user set authentication_string='' where user='foobared';
# 授权：
GRANT ALL PRIVILEGES ON xAdmin.* TO 'foobared';
# 修改密码加密方式
ALTER USER 'foobared'@'%' IDENTIFIED BY 'foobared' PASSWORD EXPIRE NEVER;
#授权三方软件链接
ALTER USER 'foobared'@'%' IDENTIFIED WITH mysql_native_password BY 'foobared';
#刷新用户权限
FLUSH PRIVILEGES;