I'm running Windows 11 and tried to install XAMPP on this machine. It installed Apache correctly, but when going to mySQL this appears:

I tried everything I found online to fix this problem in order to install WordPress locally. Then I "fixed" the problem following this tutorial Fixing connection to mySQL

After this, at least PHPmyAdmin opened. However, when installing Wordpress, it did not recognise the database (I created the database and made sure the password, the username and the name of the database were correct, together with the privileges). I spent countless hours trying each and every tutorial I found on the internet to solve this. In the end I resorted to installing XAMPP on a Windows 10 machine. Finally, everything worked out of the box (on Windows 10) without following any tutorials.

Any ideas of why this happened?

CodePudding user response：

The picture says your credentials are incorrect. Try resetting the password for the MySQL user.

CodePudding user response：

In fact, it looks like you didn't provide a proper configuration (last line in your screenshot). You need to have a config.inc.php file with appropriate credentials and server details (even in the localhost case) in the root of your phpmyadmin installation. See https://docs.phpmyadmin.net/en/latest/setup.html#quick-install-1 for reference.

Also make sure, that access for the respective user is allowed in the mySQL installation (individual database access but also mySQL configuration as well, in case of a root access https://linuxconfig.org/mysql-allow-root-remote-access, the latter being discouraged).

After that, of course make sure that your mySQL server is actually running and the firewall allows for access on the port (default: 3306) that you set, which should be the default case for connections to the localhost.