修改密码相关

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;

ERROR 1396 (HY000): Operation ALTER USER failed for \’root\’@\’localhost\’?

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

版权声明：本文为wolbo原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://www.cnblogs.com/wolbo/p/13656660.html