I recently wanted to install Joomla 4 Beta and discovered I need PHP 7 or higher. I am running XXAMP and only PHP 5.6. I also have WAMP installed and have a bunch of sites started in there. My WAMP would start; however, the sites couldn’t connect to the database.

I looked in the “C:\WAMP\apps\myphpadminX.X.X\config.inc.php” file and the password was what I thought it was. I tried a bunch of things including using the MySQL Console but this article got me working again.

https://stackoverflow.com/questions/29070501/regaining-access-to-lost-mysql-password-for-phpmyadmin-on-wamp

The lines in my “wampserver >> MySQL >> my.ini” file in the looked like this:

# The MySQL server
[wampmysqld]
#skip-grant-tables

I assumed the “#” was a comment so I removed it. I didn’t have to add it. It looked like this:

# The MySQL server
[wampmysqld]
skip-grant-tables

Restarted everything and I could log into PHPmyAdmin and all the sites were now connecting.

I hope this helps someone else out there…