Change MySQL root password

So you forgot your MySQL database password ? Don’t worry, I’ll go straight to the point:

  • Stop your running mysqld instances (/etc/init.d/mysql-server stop or killall mysqld)
  • # mysqld –skip-grant-tables
  • # mysql -uroot and you’re in, easy, isn’t it ?

For god sake, don’t do this on a production server leaving mysqld running like this X”D