I am trying to change my root password for mysql 4.1.7 running on Linux (as
I forgot it) using the docs found at:
When I get to the step:
shell> mysqladmin -u root flush-privileges password "newpwd"
I get the error:
mysqladmin: unable to change password; error: 'Can't find any matching row
in the user table'
I think my user table is screwed up but how can I get in to fix it???
Worst case, do I just uninstall and reinstall mysql?
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.822 / Virus Database: 560 - Release Date: 12/22/2004