mysql8+新增用户及密码加密规则修改

1. 用户创建

 创建用户，进行授权
mysql> create user  'lisl'@'%' identified by 'admin123';
Query OK, 0 rows affected (0.06 sec)

mysql> grant all on *.* to 'lisl'@'%' ;
Query OK, 0 rows affected (0.04 sec)

mysql> flush privileges;
Query OK, 0 rows affected (0.00 sec)

 

2、客户端登录异常

 错误号码 2058：Plugin caching_sha2_password could not be loaded

 修改加密方式：

-- 修改密码为用不过期
mysql> ALTER USER 'lisl'@'%' IDENTIFIED BY 'admin123' PASSWORD EXPIRE NEVER; 
Query OK, 0 rows affected (0.02 sec)

-- 修改密码并指定加密规则为mysql_native_password
mysql> ALTER USER 'lisl'@'%' IDENTIFIED WITH mysql_native_password BY 'admin123';
Query OK, 0 rows affected (0.01 sec)

-- 刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)