I get an error when trying to reset password.
I start the db using:
mysqld_safe --skip-grant-tables &
and reset the pwd using the mysqladmin command...
below is the error message.
mysqladmin: unable to change password; error: 'Can't find any matching row in the user
table'
thanks,
--
MySQL Ge
While trying to fix some problems with the user access privileges on
mysql4.0 alpha, I run the mysql_fix_privilege_tables script.
http://dev.mysql.com/doc/mysql/en/Upgrading-grant-tables.html
As the result, I can't get to the database, even using the root login.
I tried to recover root password
The RAID that we used to hold our mysql data was crashed a few days ago.
Although it is fine now (after switching to the secondary host connector),
we can't seem to start the mysqld.
We tried to start the server using the various innodb_force_recovery options
(1-6) with no luck.
Below is the err