MySQL5.5忘记root密码的解决办法.docx

MySql5.5忘记root密码的解决方法操作系统：windows操作系统，xp或win7.1. 进入C:Program FilesMySQLMySQL Server 5.5bin,新建cmd.bat文件，内容为 cmd.exe 双击cmd.bat,进入目录后停止mysql 服务e:mysql5.5binnet stop mysql注意:看看那任务管理器中是否有mysqld.exe进程，如有，kill them all.2. 以不检查权限的方式启动mysqle:mysql5.5binmysqld.exe -skip-grant-tables你会看到窗口光标在下一行的第一个位置闪烁，这说明已经启动了，不需要管。3. 新建一个命令行窗口同样进入到e:mysql5.5bin目录，启动mysqle:mysql5.5binmysql4. 修改root密码mysqluse mysqlmysqlupdate user set password=PASSWORD(new_password) where user=root;mysqlflush privileges;mysqlquit5. 看看那任务管理器中是否有mysqld.exe进程，如有，kill them all.6. 重启mysql，就可以用你设置新密码登陆e:mysql5.5binnet start mysqle:mysql5.5binmysql -u root -pnew_passwordthats all .默认密码是空的情况下修改密码C:xamppmysqlbinC:xamppmysqlbinmysql -u rootWelcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1378Server version: 5.5.25a MySQL Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or h for help. Type c to clear the current input statement.mysql SET PASSWORD FOR rootlocalhost = PASSWORD(root);Query OK, 0 rows affected (0.00 sec)mysql flush privileges;刷新权限注意后面的分号(;)Query OK, 0 rows affected (0.00 sec)反馈结果，表示成功mysql quit;退出登陆Bye反馈结果C:xamppmysqlbin或Microsoft Windows 版本 5.2.3790(C) 版权所有 1985-2003 Microsoft Corp.C:Documents and SettingsAdministratorcd C:cd xamppC:xamppcd mysqlC:xamppmysqlcd binC:xamppmysqlbinMySQL -u root MySQL登陆mysql 密码空Welcome to the MySQL monitor. Commands end with ; or g.Your MySQL connection id is 1830Server version: 5.5.25a MySQL Community Server (GPL)Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or itsaffiliates. Other names may be trademarks of their respectiveowners.Type help; or h for help. Type c to clear the current input statement.登陆成功mysql update user set password=password(root) where user=root;设备密码为root注意后面的分号(;)Query OK, 0 rows affected (0.00 sec)Rows matched: 2 Changed: 0 Warnings: 0反馈结果，表示成功mysql flush privileges;刷新权限注意后面的分号(;)Query OK, 0 rows affected (0.00 se