今天发现本机的mysql的密码不对,弄了半天,都登录不进去,从服务里把启动命令找到,然后添加--skip-grant-tables跳过认证
- C:> "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqld" --defaults-file="C:\Program Files\MySQL\MySQL Server 5.5\my.ini" --skip-grant-tables
- mysql> update user set password='' where user='root' and host='localhost';
- mysql> flush privileges;
阅读(2787) | 评论(0) | 转发(0) |