Re: MySQL Error Number 1045 Access denied

[Richard Phillips]

I installed PHP 5.2.1 and MySQL Server 5.0 as virgin Services on IIS in Windows XP. I had problems where PHP 5.2.1 would not recognize MySQL Server 5.0. MySQL never appeared on PHPinfo despite multiple efforts using fixes and suggestions elaborated elsewhere. Altho PHP ran normally, it did not recognize MySQL or its databases. Unable to fix it after exhaustive efforts and reinstallations of PHP to 5.2.3 and back to 5.2.1, we decided to uninstall / reinstall MySQL Server 5.0, using mysql-5.0.41-win32 since we still had the blank screen problem and lack of recognition of MySQL on PHPInfo.

With reinstall with the MySQL Setup Wizard, I was requested to configure the MySQL Server. I can only get it installed as a Windows Service without security (i.e., Username: root and no password) settings, (which makes sense since I uninstalled the prior program and have no passwords to modify). However, I am subsequently unable to 'connect to the specified instance' whether I open the SQL Adminstrator or the MySQL Query Browser 1.2.12, and I get the 'MySQL Error Number 1045' with 'Access denied for user 'root'@ ;localhost' [using password:NO]'.

Effectively I've installed 50GB of software that gives me no options to modify the installation in a way that will change this result. I am frozen out of access to anything because of the password problem. I am administrator on the machine, and there is no issue of local password security.

I tried to change permissions on the command prompt as suggested in this forum (via 'Grant ALL ON *.* to root@localhost IDENTIFIED BY 'pw'), but it doesn't help.

I'm stumped and going nowhere fast. I would appreciate any suggestions.

Thanks in advance for any help.

Richard