1 关闭MySQL服务
2 在mysql/bin/ 下运行mysqld-nt --skip-grant-tables如果报错mysql提示Changed limits: max_open_files: 2048 max_connections: 1910 table_cache: 64解决办法:
在my.ini 里可调
max_connections=1024
table_cache=64
3 起着这个cmd,重新开一个cmd到 mysql/bin/
mysql -u root
mysql> UPDATE mysql.user SET Password = PASSWORD('newpass') WHERE user = 'root';
mysql> flush privileges;
mysql> quit;
4 关闭mysqld-nt进程 启动mysql即可