MySQL误删root密码

1.停止mysql服务器。
2.my.ini中增加skip-grant-tables
3.mysql安装bin目录下执行 mysqld --console --skip-grant-tables --shared-memory --skip-networking，此窗口1保留
4.mysql安装bin目录下再开一个窗口2 执行 mysql

5.添加用户
use mysql

insert into user(Host,User,authentication_string,ssl_cipher,x509_issuer,x509_subject) values(‘localhost’,‘root’,‘’,‘’,‘’,‘’);

update user
set
select_priv=‘y’,
insert_priv=‘y’,
update_priv=‘y’,
delete_priv=‘y’,
create_priv=‘y’,
drop_priv=‘y’,
reload_priv=‘y’,
shutdown_priv=‘y’,
Process_priv=‘y’,
file_priv=‘y’,
grant_priv=‘y’,
References_priv=‘y’,
index_priv=‘y’,
Alter_priv=‘y’,
show_db_priv=‘y’,
super_priv=‘y’,
create_tmp_table_priv=‘y’,
Lock_tables_priv=‘y’,
execute_priv=‘y’,
repl_slave_priv=‘y’,
repl_client_priv=‘y’,
create_view_priv=‘y’,
show_view_priv=‘y’,
create_routine_priv=‘y’,
alter_routine_priv=‘y’,
create_user_priv=‘y’,
Event_priv=‘Y’,
Trigger_priv=‘Y’,
Create_tablespace_priv=‘Y’,
Create_role_priv=‘Y’,
Drop_role_priv=‘Y’
where user=‘root’ and Host=‘localhost’;

commit;

6.关闭窗口2
7.Ctrl+C退出窗口1
8.注释掉参数skip-grant-tables
9.启动mysql服务器
10.登录mysql修改密码 mysql安装bin目录下 执行 mysql -uroot -p
alter user ‘root’@‘localhost’ identified with mysql_native_password by ‘root@12345’;