Re: help! recover from running mysql_fix_privilege_tables on mysql4.0

2004-04-16 Thread Egor Egorov
Rusma Mulyadi [EMAIL PROTECTED] wrote: 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

Re: Re: help! recover from running mysql_fix_privilege_tables on mysql4.0

2004-04-16 Thread Rusma Mulyadi
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