在配置my.ini下mysqld下添加
skip-grant-tables=1 #账户免密码验证
use mysql;
mysql5.6使用以下修改密码
mysql> update mysql.user set password=password('admin12345') where user='root';
mysql8.0以上使用以下是修改
#清除root密码
mysql> update mysql.user set authentication_string='' where User='root';
mysql> flush privileges;
修改root用户的localhost权限
mysql> update mysql.user set Grant_priv='Y',Super_priv='Y' where user='root';
mysql> flush privileges;
mysql> grant all on *.* to 'root'@'localhost';
#root清除账户被锁
mysql> flush privileges;
mysql> ALTER USER 'root'@'localhost' ACCOUNT UNLOCK;
mysql> ALTER USER 'root'@'%' ACCOUNT UNLOCK;
mysql> update mysql.user set account_locked='N' where user='root';
mysql> commit;
#修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'admin12345';
mysql> flush privileges;
评论