–skip-grant-tables参数用起来
先关掉系统服务
实测,在mysql8系统下,用
mysqld --console --skip-grant-tables --shared-memory 可以无密码启动服务
服务启动后,以空密码登入系统
mysql.exe -u root
ALTER USER 'root'@'localhost' IDENTIFIED BY 'abc123456' PASSWORD EXPIRE NEVER;
alter user 'root'@'localhost' identified by 'abc123456';
grant all privileges on *.* to "root"@'localhost';
flush privileges;