Password reset under CentOS and Windows2003server systems

1 mysql password hack under Linux system

First of all, you need to confirm that the server is no one can connect, because during the period of resetting the MySQL password, the database is completely without password protection in the state of the situation, other users can also login to modify the MySQL information , so you can take the method of shutting down the port and stopping the user process to prevent it.

The first step: Modify the mysql login settings, the following add skip-grant-tables, skip permission detection, save exit;

650) this.width=650; "style=" Float:none; "title=" 1.png "src=" http://s3.51cto.com/wyfs02/M02/71/99/ Wkiom1xuni6rdaxqaaauomsjo04077.jpg "alt=" Wkiom1xuni6rdaxqaaauomsjo04077.jpg "/>

650) this.width=650; "style=" Float:none; "title=" 2.png "src=" http://s3.51cto.com/wyfs02/M00/71/96/ Wkiol1xuod3wdbogaadhoztjsjc453.jpg "alt=" Wkiol1xuod3wdbogaadhoztjsjc453.jpg "/>

             

Step Two: Restart MySQL daemon

650) this.width=650; "title=" 3.png "src=" Http://s3.51cto.com/wyfs02/M02/71/96/wKioL1XUOIXzcRZzAAB6Is9A8j4378.jpg " alt= "Wkiol1xuoixzcrzzaab6is9a8j4378.jpg"/>

Step three: Enter the database to change the password

650) this.width=650; "title=" 4.png "src=" Http://s3.51cto.com/wyfs02/M00/71/96/wKioL1XUOL2jwnZjAACaJ4Cjg2I714.jpg " alt= "Wkiol1xuol2jwnzjaacaj4cjg2i714.jpg"/>

650) this.width=650; "title=" 5.png "src=" Http://s3.51cto.com/wyfs02/M01/71/99/wKiom1XUNtjw0wQNAACNSKZZSzE877.jpg " alt= "Wkiom1xuntjw0wqnaacnskzzsze877.jpg"/>

650) this.width=650; "title=" 6.png "src=" Http://s3.51cto.com/wyfs02/M02/71/96/wKioL1XUOPmxZLI7AAB_9nzkFlY358.jpg " alt= "Wkiol1xuopmxzli7aab_9nzkfly358.jpg"/>

650) this.width=650; "title=" 7.png "src=" Http://s3.51cto.com/wyfs02/M00/71/99/wKiom1XUNxei5s3nAABcLUw8fs4656.jpg " alt= "Wkiom1xunxei5s3naabcluw8fs4656.jpg"/>

Fourth step: Exit the database restore login settings and restart the service

650) this.width=650; "title=" 8.png "src=" Http://s3.51cto.com/wyfs02/M01/71/99/wKiom1XUNyfy3PcMAABpBGIKqjo397.jpg " alt= "Wkiom1xunyfy3pcmaabpbgikqjo397.jpg"/>

650) this.width=650; "title=" 9.png "src=" Http://s3.51cto.com/wyfs02/M02/71/99/wKiom1XUNzrBxzvkAABwnWkyJ4I923.jpg " alt= "Wkiom1xunzrbxzvkaabwnwkyj4i923.jpg"/>

Fifth step: Check whether the configuration is correct or not, show success

650) this.width=650; "title=" 10.png "src=" http://s3.51cto.com/wyfs02/M02/71/99/wKiom1XUN1HSEBfLAAC69N1jepc519.jpg "alt=" wkiom1xun1hsebflaac69n1jepc519.jpg "/>

2 mysql password hack under the Windwos2003 system

First step: Stop the MySQL service process;

650) this.width=650; "title=" 1.png "src=" Http://s3.51cto.com/wyfs02/M02/71/9A/wKiom1XUOAHSGV0HAABFzzmlg3A113.jpg " alt= "Wkiom1xuoahsgv0haabfzzmlg3a113.jpg"/>

Step two: Start without checking permissions MySQL

650) this.width=650; "title=" 2.png "src=" Http://s3.51cto.com/wyfs02/M02/71/9A/wKiom1XUOBPy5k8gAABl214V5F0448.jpg " alt= "Wkiom1xuobpy5k8gaabl214v5f0448.jpg"/>

Step three: Use MySQL client does not enter password login mysql

650) this.width=650; "title=" 3.png "src=" Http://s3.51cto.com/wyfs02/M01/71/9A/wKiom1XUOCuQz-m9AAEjEof8ijU357.jpg " alt= "Wkiom1xuocuqz-m9aaejeof8iju357.jpg"/>

Fourth step: Set a new password

650) this.width=650; "title=" 4.png "src=" Http://s3.51cto.com/wyfs02/M01/71/9A/wKiom1XUOD_AAQMvAABO1QyKxFg595.jpg " alt= "Wkiom1xuod_aaqmvaabo1qykxfg595.jpg"/>

Fifth step: Refresh MySQL permissions and exit

650) this.width=650; "title=" 5.png "src=" Http://s3.51cto.com/wyfs02/M02/71/96/wKioL1XUOlmDU4ewAABEJLY-UAc470.jpg " alt= "Wkiol1xuolmdu4ewaabejly-uac470.jpg"/>

Sixth step: End in Task Manager mysqld Process

650) this.width=650; "title=" 6.png "src=" Http://s3.51cto.com/wyfs02/M01/71/9A/wKiom1XUOFviEGVcAAA8lkoqjVA755.jpg " alt= "Wkiom1xuofviegvcaaa8lkoqjva755.jpg"/>

Seventh Step: Start MySQL service

650) this.width=650; "title=" 7.png "src=" Http://s3.51cto.com/wyfs02/M02/71/96/wKioL1XUOnWxDbp5AAA9GBe3kwo958.jpg " alt= "Wkiol1xuonwxdbp5aaa9gbe3kwo958.jpg"/>

Eighth Step: Login Verification Success

650) this.width=650; "title=" 8.png "src=" Http://s3.51cto.com/wyfs02/M00/71/96/wKioL1XUOoKjes9PAAERstBqe_0522.jpg " alt= "Wkiol1xuookjes9paaerstbqe_0522.jpg"/>

Password reset under CentOS and Windows2003server systems