Article by Aashish
This article explains the process that will allow you to recover a lost MySQL password:
Stop the MySQL server process
Start the MySQL (mysqld) server/daemon process with the
–skip-grant-tables option so that it will not prompt for password.
Connect to mysql server as the root user.
Setup new mysql root account password.
Exit and restart the MySQL server.
Example:
# service mysqld stop
Output:
Stopping MySQL database server: mysqld.
Then start MySql in safe mode
# mysqld_safe –skip-grant-tables
Output
[1] 5988
Starting mysqld daemon with databases from /var/lib/mysql
Then connect the mysql without any password
# mysql -u root
( Then setup password )
mysql> use mysql;
mysql> update user set password=PASSWORD(”NEW-ROOT-PASSWORD”) where User=’root’;
mysql> flush privileges;
mysql> quit
Then stop mysql
# service mysql stop
# service mysql start
Then Try your new password :
# mysql -u root -p
Good Luck!
34 Responses to How to Recover a Lost MySQL Password
Alexander7
July 19th, 2011 at 11:26 pm
buy@generic.LEVITRA” rel=”nofollow”>……
Need cheap generic LEVITRA?…
EDUARDO
July 29th, 2011 at 5:41 am
Buy@Cheap.Abana” rel=”nofollow”>..…
Buygeneric pills…
PERRY
July 29th, 2011 at 2:35 pm
Purchase@Abilify.Online” rel=”nofollow”>……
Buywithout prescription…
ROY
July 29th, 2011 at 9:26 pm
Buy@Generic.Abilify.5mg.10mg.15mg.20mg.30mg” rel=”nofollow”>……
Buywithout prescription…
RUSSELL
July 30th, 2011 at 4:19 pm
Purchase@Discount.Acai” rel=”nofollow”>..…
Buywithout prescription…
SALVADOR
July 30th, 2011 at 10:44 pm
Buy@Acai.Without.Prescription” rel=”nofollow”>……
Buynow…
EDUARDO
July 31st, 2011 at 2:37 pm
Buy@Cheap.Coral.Calcium” rel=”nofollow”>.…
Buynow it…
RONALD
August 1st, 2011 at 1:02 am
Buy@Cheap.Coral.Calcium” rel=”nofollow”>……
Buygeneric meds…
DUSTIN
August 1st, 2011 at 4:05 am
Cheap@Coral.Calcium.Online” rel=”nofollow”>..…
Buygeneric drugs…
SALVADOR
August 1st, 2011 at 6:55 am
Order@Discount.Abana” rel=”nofollow”>..…
Buygeneric meds…
EVERETT
October 17th, 2011 at 12:29 am
levaquin 500mg…
Buy_no prescription…
ALBERT
October 20th, 2011 at 11:35 am
financial aid for alzheimer’s…
Buy_without prescription…
TODD
October 20th, 2011 at 7:54 pm
heart worm medication…
Buy_no prescription…
ANTONIO
October 22nd, 2011 at 12:45 am
blood pressure medications…
Buy_now it…
BARRY
October 25th, 2011 at 8:26 pm
hepatitis b shot…
Buy_it now…
DAN
October 26th, 2011 at 4:46 am
drug trafficking in latin america…
Buy_drugs without prescription…
LAWRENCE
October 29th, 2011 at 5:19 am
permanent removal of adult acne scars…
Buy_generic meds…
KENNY
October 30th, 2011 at 8:44 am
enhancement drugs…
Buy_no prescription…
TERRENCE
October 30th, 2011 at 8:22 pm
drug test company…
Buy_without prescription…
JACOB
October 31st, 2011 at 1:03 pm
social etiologies for patients with schizophrenia…
Buy_it now…
ERIC
November 2nd, 2011 at 11:43 am
epson salt and lemon juice diet…
Buy_generic pills…
BRYAN
November 2nd, 2011 at 4:43 pm
l91 energizer e2 lithium aa cells…
Buy_generic drugs…
JOEY
November 3rd, 2011 at 6:03 am
how to buy glucose meter…
Buy_generic meds…
JEREMY
November 3rd, 2011 at 11:49 am
skin cancer foundation australia…
Buy_generic drugs…
CHRIS
November 4th, 2011 at 10:07 pm
clinical features of sickle cell disease…
Buy_generic drugs…
JEFFERY
November 6th, 2011 at 5:47 am
depression medcine xr…
Buy_drugs without prescription…
CHARLIE
November 8th, 2011 at 12:01 pm
school age adhd self absorbed…
Buy_now it…
NATHAN
November 11th, 2011 at 6:21 pm
meal plan for hypertension…
Buy_generic drugs…
RAFAEL
November 12th, 2011 at 5:41 pm
scabies in dogs help…
Buy_generic drugs…
ALFRED
November 13th, 2011 at 5:22 am
herbals for pregnancy…
Buy_drugs without prescription…
WESLEY
November 16th, 2011 at 9:59 pm
diet secrets for models…
Buy_now it…
ALLEN
December 10th, 2011 at 4:06 am
pietro@atrovent.buy” rel=”nofollow”>……
Buygeneric meds…
JEREMY
December 11th, 2011 at 11:24 am
best@medicare.plan.d.for.nexium.40.mg” rel=”nofollow”>..…
Buygeneric meds…
HARRY
December 11th, 2011 at 3:39 pm
infant@prevacid.dose” rel=”nofollow”>.…
Buygeneric drugs…