Posts Tagged ‘MySQL’

Reset MySQL Root Password

Tuesday, April 13th, 2010
  1. /etc/init.d/mysql stop
  2. Start MySQL: mysqld_safe –skip-grant_tables -u root &
  3. mysql -u root
  4. mysql> update mysql.user set Password=PASSWORD(‘newpassword’) where User=’root’;
  5. mysql> flush privileges;
  6. /etc/init.d/mysql stop
  7. /etc/init.d/mysql start

Tags:
Posted in Uncategorized | No Comments »