MySQL Password lost back
Steps
1 Stopping the database
/etc/init.d/mysqld stop
2 Starting the database service with the--skip-grant-tables ignore authorization table
/usr/local/mysql/bin/mysqld_safe--skip-grant-tables &
3 MySQL Direct access change password
Update Mysql.user set Password=password (' c110123 ') where user= ' root ' and host= ' localhost ';
Flush privileges;
4 exit
Quit
5 Restart Mysqld, first close
In this way to close
mysqladmin-uroot-pc110123 shutdown
You can't use/etc/init.d/stop at this time because it's mysqld_safe started.
6 Start
/etc/init.d/mysqld start
650) this.width=650; "src="/e/u261/themes/default/images/spacer.gif "style=" Background:url ("/e/u261/lang/zh-cn/ Images/localimage.png ") no-repeat center;border:1px solid #ddd;" alt= "Spacer.gif"/>
This article is from the "Tridewah operation and maintenance work Road" blog, please be sure to keep this source http://cuidehua.blog.51cto.com/5449828/1762141
MySQL forgot password