Re: MySQL Error Number 1045 Access denied

[gary jones]

solved THANKS TO
List: mysql
Subject: RE: installing mysql / error
From: Tom Crimmins <mysql2 () pottcounty ! com>
Date: 2004-12-30 19:32:13
Message-ID: 4D6F6B56C91BD8118ED300E01828E4098C1377 () exmail ! pottcounty ! lan
[Download message RAW]


shutdown the mysql server. Then start it from a command line using:

[PATH TO MYSQL BINS]/mysqld-nt --skip-grant-tables

Then open another command prompt and run 'mysql -u root' and run the
following query:

UPDATE mysql.user SET Password='' WHERE User='root' AND Host='localhost';

Then shutdown the server, and restart it normally. You should then be able
to connect with 'mysql -u root'.
IT WORKED
I OPENED MYSQL ADMINISTRATOR AND GOT IN NOT SPECIFYING A PASSWORD THEN SET ONE UP IN THERE.
I HOPE THIS HELPS OTHERS I WASTED TWO DAYS FINDING THE ANSWER