Connection Error (usually when MySQL is being installed over a previous version)
 

I installing and configuring Apache 2.2.4, MySQL 5.0.27 and PHP 5.2.1 on Microsoft Windows XP.

In some cases (usually when MySQL is being installed over a previous version), the MySQL Server Instance Configuration Wizard will give a Connection Error..
:icon_sad:
Problem occur when setting security options:

1.(i don't know current password)
2.enter root password
3.Confirm (retype) your password


error number 1045: the security setting could not be applied.
access denied for user 'root'@'localhost'

Any1 can help in tis installation. thanks..

Re: Connection Error (usually when MySQL is being installed over a previous version)
 

Seems like the configuration wizard is not applying the new password so it leaves the root password blank.

When you start the MySQL command line client... just press ENTER when you are prompted for the password.

Change the root password by executing:

SET PASSWORD FOR 'root'@'localhost' = PASSWORD('MyNewPassword');



Maybe that will help.