The specified password for user account 'root' is not valid, or failed to connect to database server

php mysql wordpress iis-8 web-platform-installer
Ahsan picture Ahsan · May 2, 2017 · Viewed 8.3k times · Source

I am getting this error while installing WordPress using Windows platform installer 5.0 on a Windows Server 2012R2.

Currently I have a php site with mySQL on that server which is running fine, PHP, MYSQL was already installed as part of setting up that site couple of months ago.

MySQL .NET Connector was already installed, I have repair it(http://dancerscode.com/blog/the-annoying-mysql-web-platform-installer-bug/) using latest installer as well. Installed WebMatrix3 which was mentioned in same article but No luck.

I have made sure that mySQL password is correct by logging in using command line.

Any idea? enter image description here

Answer

Ahsan picture Ahsan · May 3, 2017

Finally found the solution.

I had Connector/Net 6.9.9 installed

I uninstalled it and then Installed Connector/Net 6.4.6

Old version of Connector can be downloaded here(https://dev.mysql.com/downloads/connector/net/)

Related questions

Php - Your PHP installation appears to be missing the MySQL extension which is required by WordPress

How do I fix the error below? Your PHP installation appears to be missing the MySQL extension which is required by WordPress. I use my NAS with a telnet connection. I installed FFP 0.7 My php.ini is in: ffp/etc/…

Read More
WooCommerce products showing “Out of stock” message when not actually out of stock

Having an issue with a client website where products are randomly displaying "This product is currently out of stock and unavailable." The thing is that we don't have inventory tracking turned on, all products should be in stock all the …

Read More
Warning: mysqli_real_connect(): (HY000/2002): No such file or directory in /private/tmp/wordpress/wp-includes/wp-db.php on line 1452

I'm trying to run PHPUnit to unittest a WordPress plugin, but the error in the title keeps showing up. I used WP-CLI to setup the unittests, but also WP-CLI throws a similar error when I try to run it. I …

Read More