Re: Error Nr. 1045 Access denied for user 'root'@'localhost' (Using password: NO)

[Daywan Singh]

Hi,
Put the following command in a batch file, stop the MySQLd.exe service. Run the batch file with this command:

"C:\Program Files (x86)\MySQL\MySQL Server 5.1\bin\mysqld.exe" --defaults-file="C:\Program Files

(x86)\MySQL\MySQL Server 5.1\my.ini" --init-file=C:\Users\Administrator\downloads\grant_root.txt --console

The text file has this command:

GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'Your password';

Note: GRANT is a command on a single line.

It looks as though when you try to install MySQL on Windows Server 2008, it failed to setup the last task (implementing security - I believe) and the MySQL.Users table is not populated properly.

Regards.