Posts Tagged ‘root password’

If you missed your mysql root user password, then here are the steps to reset it:

  1. stop mysql server
    service mysqld stop
  2. make sure all mysql process are dead
    ps -A | grep mysql
  3. start mysqld in safe mode
    mysqld_safe –skip-grant-tables
  4. open a new shell window and start mysqld
    service mysqld start
  5. access mysql database
    mysql -u root mysql
  6. reset password of root user
    update user set Password=PASSWORD(‘yournewpassword’) where user=’root’;
  7. stop mysqld_safe and restart mysql server
    service mysqld restart.

Happy Administration!

Read Full Post »