MySQL密码丢失解决和密码重置（国外英文资料）.doc

MySQL密码丢失解决和密码重置（国外英文资料） This MySQL is a bit weird, and suddenly I cant log in with my original account (for specific reasons, I know what to do); So you decide to change the original password. Stop MySQL and restart the MySQL command in an unauthorised way: Under Linux, run/usr/local/mysql/bin/mysqld_safe - skip grant - tables Under Windows, run X at the command line: / MySQL/bin/mysqld - skip - grant tables In the command line, mysql - u-root is logged in Change the password, and I wont be too much of a verbose, as a blogger (/u/29134/showart_37385html) writes. Either way The novice is prone to error in this way, causing you to be unable to get into MYSQL, which is very frustrating. Im going to do a couple of examples and Im sure youll see. The original password is 123456 C: \ type mysql5. Bat @ echo off Mysql - uroot - p123456 - P3306 The correct format for modifying MYSQL user passwords is: Here we use User: root (can be replaced with other) Password: woshiduide To demonstrate the new password. C: \ mysqladmin-uroot-p password woshiduide Enter password: * * * * So the change was successful. Note the space behind the PASSWORD keyword There are many people who have changed this: C: \ mysqladmin-uroot-p password woshiduide Enter password: * * * * C: \ mysqladmin-uroot-p password woshiduide Enter password: * * * * * * Warning: single quotes were not trimmed from the password by your command Line client, as you might have expected. And the real password is woshiduide C: \ , mysql - uroot - p woshiduide Welcome to the MySQL monitor. Or \ g. Your MySQL connection id is 18 Server version: 5.1.17-beta-community - nt-debug MySQL community Server (GPL) Type help. or \ h for help.type \ c to clear the buffer. Mysql And the novice often does this: C: \ mysql - uroot-pwoshiduide ERROR 1045 (28000) : Access denied for user root @ localhost (using password: Y) ES) So it was very frustrating, and there was a lot of search for BAIDU and GOOGLE. Im going to change the pass