在ubuntu中重置mysql root密码

sudo service mysql stop

sudo mysqld --user=mysql --skip-grant-tables --skip-networking &

 

########### note $pid

 

mysql -u root mysql

mysql> update user set Password=PASSWORD('mynewpasswd') where user='root';

mysql> FLUSH PRIVILEGES;

mysql> quit;

sudo kill $pid

sudo service mysql start

http://www.jb51.net/article/31545.htm