Koozali.org: home of the SME Server

Legacy Forums => Experienced User Forum => Topic started by: paulham on October 24, 2001, 12:54:04 PM

Title: Mysql php issues
Post by: paulham on October 24, 2001, 12:54:04 PM

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.

Title: Re: Mysql php issues
Post by: Geoff Bennion on October 24, 2001, 04:21:01 PM

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.