When I create a new database user in phpMyAdmin, if I set the host to "%" (any host), the user won't be able to connect from localhost. For example, if some php script uses that username to connect to mysql, it will not be able to connect. I am forced to set the host to "localhost" when I create the user, and it works, but this is annoying because it will allow the user to connect only from localhost.
Note that this only happens with Xampp. With any other server I have ever tried, "any host" works just fine.
Is there a fix for this?