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 Ge

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

help! recover from running mysql_fix_privilege_tables on mysql4.0

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