This article shows you how to set, change, and recover secure passwords for your MySQL root account, so you'll never be at a loss.

mysql Ver 14.12 Distrib 5.0.77, for redhat-linux-gnu (i686) using readline 5.1 I need to work on MySQL about once every six months, so it's always an exciting re-learning experience ;) Anyway, I ...

Then the password XXXXXX part is where the new password is set. <BR><BR>I wrongly figured that the -u root -p password was the combination for telling the user AND the user's password in order to ...