While installing WordPress 3.4 via Web Platform Installer 4.0 on IIS 7, at some point the Web Platform Installer asks for MySQL ‘root’ user password. There you might get this error: “The specified password for user account ‘root’ is not valid, or failed to connect to the database server”. That happens even if you enter the correct password.
Here is how to fix it:
- In the Windows registry, delete the mysql_pwd reg key under HKCU\Software\Microsoft\WebPlatformInstaller
- Download and install the latest MySql .NET Connector (32 bit). At the time of writing, the latest version of MySql .NET Connector was 6.6.4.