Change MySQL root password

Roman Valls Guimerà bio photo By Roman Valls Guimerà Comment

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

comments powered by Disqus