Solve the Problem of forgetting the root password in ubuntu 11.10 mysql

Ubuntu 11.10 mysql forget the root password solution 1. Run # killall mysqld 2 under the root account, and then run the following command www.2cto.com # mysqld -- skip-grant-tables // stop in the command line 3. Open a new command line, then run the command to change the root password # update user set PASSWORD = password ("new PASSWORD") where user = "root"; # flush privileges; # exit 4. log on to mysql with the new password in the command line. The ERROR message is: www.2cto.com ERROR 2002 (HY000 ): can't connect to local MySQL server through socket '/var/run/mysqld. sock '(2) indicates that mysql services are not up and run the following command: #/etc/init. d/mysql start // indicates starting mysql #/etc/init. d/mysql stop // mysql stop