Topic: Mysql php issues

[paulham]

Hi,
I have worked out problems with myql when installing php software like webcal, and zorum.

I ran
> mysql -u root mysql
>UPDATE user SET Password=PASSWORD ('new_password') WHERE user='root';
> FLUSH PRIVILEGES;

but now mysql will not allow me to run it I get this
 ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES)

is there an easy way to reset the password?

I would like to avoid reinstalling

Paul

BTW I have searched the archive but most of the messages tell people to search form other meassages in the archive.

[Geoff Bennion]

yes,
in /root there will be a file called .my.cnf
in here is the encrypted version of the root password,
just use an UPDATE like this
UPDATE user SET Password='paste-encrypted-password-here' WHERE user='root'
Flush privs
and voilla.