Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

share|improve this question

migrated from Jun 20 '11 at 8:14

This question came from our site for professional and enthusiast programmers.

what is your root password? does it even have a password? – Yasser Souri Jun 20 '11 at 5:37
Think he has just installed and doesnt know where to change – Balanivash Jun 20 '11 at 5:38
its pwd error..not Windows 7 security error.. – thecodejack Aug 7 '12 at 7:06

I had this problem, and explicitly running the MySQL installer as Administrator (right-click, select 'Run as Administrator') fixed it for me.

share|improve this answer

Was the provided password correct?

Otherwise please check here:,39440,417422#msg-417422

share|improve this answer
# /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> quit

# /etc/init.d/mysql restart
# mysql -uroot -p
Enter password: <newpassword>
share|improve this answer
Your answer is for a linux system and in the question it has been specifically stated that the problem is in wondows – Balanivash Jun 20 '11 at 5:59

Where you installed the mysql, there should be a file called my.cnf or my.ini, in there should be the root password .e.g

C:\Program Files\MySQL\MySQL Server 4.1\my.ini

share|improve this answer

You must log in to answer this question.