Monday, January 12, 2009

Reset MySQL root password

For Redhat,
Just a reminder for a working solution.

  • service mysqld stop
  • mysqld_safe --skip-grant-tables &
  • mysql -u root mysql
  • UPDATE user SET Password=PASSWORD('new_password') WHERE user='root';
  • FLUSH PRIVILEGES;
  • exit
  • service mysqld start

No comments: