mysql 8 修改密码

先登录

	./mysql -uroot -p
	回车输入密码

选择数据库

use mysql

修改密码命令

	alter user 'root'@'%' identified by '123456';
	flush privileges;

给新用户设置密码

	// 创建用户
	CREATE USER 'test'@'%' IDENTIFIED BY '123456';
	// 授予所有权限
	grant all on *.* to 'test'@'%';

问题1

如果连接报错：
client does not support authentication protocol requested by server; consider upgrading MySQL client

// 修改默认加密方式 在my.cnf [mysqld]下面加上:
// 重启mysql在新建用户
default_authentication_plugin=mysql_native_password

//或者使用
alter user 'test'@'%' identified with mysql_native_password by '123456';

查看用户加密方式

select host,user,plugin,authentication_string from mysql.user;

问题2

修改密码报错：
Access denied; you need (at least one of) the SYSTEM_USER privilege(s) for this operation

//授予root用户权限
grant system_user on *.* to 'root'