1 message in com.mysql.lists.win32getting ERROR 1045: Access denied for...
FromSent OnAttachments
Jose Rosengurtt26 May 2003 11:56 
Subject:getting ERROR 1045: Access denied for user: 'test1@127.0.0.1' (Using password: YES) on W2K
From:Jose Rosengurtt (rose@yahoo.com)
Date:05/26/2003 11:56:39 AM
List:com.mysql.lists.win32

HI Damien

I had the same problem. The way I found out to set the password for the root
user is this:

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

I took this piece of code from the page:

http://www.mysql.com/doc/en/Default_privileges.html

Regards

Jose Rosengurtt (rose@yahoo.com)