mysql10061+unknow+error_mysql 8.0.21 10061 unknown error

修改密码相关

1 配置文件中my.cnf 的配置项msqld下面增加

skip-grant-tables

2 mysql -u root 登进去

切换mysql数据库

use mysq

密码置空

UPDATE user SET authentication_string = '' WHERE User = 'root';

退出后重启mysql服务

登陆

mysql -u root -p

回车

设置弱口令

set global validate_password.policy=0;

ALTER user 'root'@'localhost' identified by 'simplepass';

flush privileges;

https://stackoverflow.com/questions/5555328/error-1396-hy000-operation-create-user-failed-for-jacklocalhost

drop user admin@localhost;

flush privileges;

create user admin@localhost identified by 'admins_password'

10061 unknown error

#skip-grant-tables很多时候是没权限

--给root权限

UPDATE mysql.user SET Grant_priv='Y', Super_priv='Y' WHERE User='root';--刷新权限

FLUSH PRIVILEGES;

--授权所有权限

GRANT ALL ON *.* TO 'root'@'localhost';

参考:

https://blog.csdn.net/god_wen/article/details/78961319