Had a field day messing around with MySQL root password because all of a sudden the security team decides they want to make sure third party software follows their rules. I guess they have new goals for this year.
So I tried many methods, using mysqladmin command to reset doesnt work for some weird and unknown reason, and it always end up screwing the root account that I cant login with it anymore. Maybe its just me, but I always have problem with MySQL root account, maybe it just hates me.
The only success comes when I use the steps listed here, and voila, all the steps works like magic, EXCEPT for the last one which I think should be modified.
After you are finished close the first command prompt and type “exit;” in the second command prompt windows to disconnect successfully. You can now start the MySQL service.
You see, if I close the first cmd window that starts the mysqld process, that process refuses to die and I will not be able to start MySQL service normally after that. The correct way to do this would be to manually shutdown the mysqld process from the Task Manager window, and then start the MySQL service.
But anyhow, this is the only method that works for me, and I am thankful.