Linux/MySQL

= MySQL tips =

How to reset MySQL root passowrd ?
service mysqld stop

ps aux | grep mysql

mysqld_safe --skip-grant-tables &

mysql --user=root mysql

update user set Password=PASSWORD('INSERT_YOUR_PASSWORD_HERE') where user='root'; flush privileges; exit;

killall mysqld

ps aux | grep mysql

service mysqld start
 * source: http://www.howtoforge.com/reset-forgotten-mysql-root-password