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 ...

This user cannot be called “root” because, depending on how the MySQL server is configured, it may not be possible to add an account with remote access that is named “root.” ...