Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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 stackoverflow.com 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.. –  CodeJack Aug 7 '12 at 7:06
add comment

4 Answers 4

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
add comment

Was the provided password correct?

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

share|improve this answer
add comment
# /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>
share|improve this answer
1  
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
add comment

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
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.