Nov 072009
This is a common problem among programmers who are lazy to remember passwords and finally a reminder machine. but what if the engine suddenly broken and the reminder had no backups. hehehe …. forgotten it. right?
if you forget, reset the root password. easy right? 
problem is how do I reset the root password?
this is the way:
1. we first used to turn off the server, the server did not mean a whole but only mysql service. hehehe …
of course, is how to turn them off from the root linux via the command:
# /etc/init.d/mysql stop
2. then create a sql script to change the password with the command
# vi /root/mysql.reset.sql
or with other commands you like such as pico or nano .
