Mysql Tricks

reset password

#first stop current mysql server
sudo service mysqld stop


#start mysqld_safe without grant and networking[security reason] in background
sudo mysqld_safe --skip-grant-tables  --skip-networking &

#login as root
mysql -uroot

# reset root password
set @password='#MY_PASS_WORD_HERE#'
update mysql.user set password=password(@password) where user='root';

#apply new privileges;
flush privileges;

#sair
exit;


#stop mysql to stop mysqld_safe
sudo  service mysqld stop

#start mysql normally

sudo service mysql start