Reset mysql password?

[slevytam]

Hi,

I was wondering if someone could help me. I am trying to reset the password for my mysql server.

I have done the following steps

/etc/rc.d/init.d/mysql stop

safe_mysqld --skip-grant-tables &

this brings up

Starting mysqld daemon with databases from /var/lib/mysql

Then I try mysqladmin -u root password 'root'

and I get

mysqladmin: unable to change password; error: 'You must have privileges to update tables in the mysql database to be able to change passwords for others'

I am logged in as the root user. Can anyone help me out?

Thanks,

Shalom

[steadyguy]

Did you use a FLUSH PRIVILEGES statement? You need to do this first thing after logging in. It will remove all privileges, and reactivate GRANT commands, and then you can reset your password.

[slevytam]

thanks will give it a try.

--SL