mysql8常见问题和解决方法

允许所有ip访问

1.use mysql;//切换使用mysql数据库
2.select user,host from user;   //查看用户是否开启远程
3.update user set host='%' where user='root';  //开启远程
4.flush privileges;//刷新权限

 

 

异常2059-Authentication plugin 'caching_sha2_password' cannot be loaded解决方法

 

0.use mysql;
1.alter user 'root'@'%' identified by 'password' PASSWORD EXPIRE NEVER;
2.ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY '旧密码';
3.FLUSH PRIVILEGES; 
4.alter user 'root'@'%' identified by '新密码';

 

 

事务所强制释放

1. SELECT * from information_schema.INNODB_TRX; //查询事务信息
2. kill xxx; //trx_mysql_thread_id

 

后续遇到一些问题和解决方法不断记录中...