用户密码:8.0 配置mysql_native_password身份验证插件的密码
方法一:
登录MySQL后输入:
ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘YourPassword’;
FLUSH PRIVILEGES;
方法二:
编辑my.cnf文件,更改默认的身份认证插件。
vi /etc/my.cnf
在[mysqld]中添加下边的代码
default_authentication_plugin=mysql_native_password
然后重启MySQL
service mysqld restart
用户lock: 锁定状态
通过执行create user/alter user命令中带accout lock/unlock子狙设置用户的lock状态
Create user语句默认的用户是unlock状态
mysql>create user abc2@localhost identified by‘mysql’account lock;
Query OK,0rows affected (0.01sec)
Alter user语句默认不会修改用户的lock/unlock状态
mysql>alter user‘mysql.sys‘@localhost account lock;
Query OK,0rows affected (0.00sec)
mysql>alter user‘mysql.sys’@localhost account unlock
Query OK,0 rows affected ÿ