How to Reset a Lost MySQL Password
Submitted by Aaron Longwell on Mon, 2007-04-23 10:44.mysqld --skip-grant-tables & mysql -h 127.0.0.1 mysql
1 ALL PRIVILEGES ON * TO root@localhost IDENTIFIED BY 'password'; 2 FLUSH PRIVILEGES; 3 ALL PRIVILEGES ON * TO root@localhost IDENTIFIED BY 'password'; 4 FLUSH PRIVILEGES; 5 QUIT;
