lost root password to mysql?

[sfullman]

OK, I think I might have inadvertantly changed the root password to mysql? I do have root access to the server however.

Any suggestions on how to handle this?

Thanks very much.

Sam Fullman

[tsinka]

Hi,

login as root user then stop mysql and start mysqld with --skip-grant-tables (e.g. /usr/sbin/safe_mysqld --skip-grant-table).

Login to the mysql server wit "mysql -h localhost mysql"

change the root password (update user set password=password('the new password') where user='root').

Flush the privileges with "flush privileges".

stop the database

start the database as usual