How to install MySQL on Windows 7

Question

Please help me how to install MySQL on Windows 7. When I tried to install, I am getting errors as:

The security settings could not be applied to the database because the connection has failed of the following errors

ERROR NR:1045 Access denied for user 'root@'localhost(using password yes).

I tried to uninstall MySQL completely and install again, but it shows this error again and again. I have changed my firewall setting also and tried unstalling antivirus sotware too. But it also did not work.

Answer 1

Was the provided password correct?

Otherwise please check here: http://forums.mysql.com/read.php?11,39440,417422#msg-417422

Answer 2

# /etc/init.d/mysql stop
# mysqld_safe --user=mysql --skip-grant-tables --skip-networking &
# mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('newpassword') where USER='root';
mysql> FLUSH PRIVILEGES;
mysql> quit

# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <newpassword>