MySQL Access denied for all but root

[johnlanglois]

I am running XAMPP on a Windows XP SP2 machine in a separate drive.
I used the XAMPP admin to set the password for the root user.
I have setup several databases and created users to whom I have given full access privileges.

A couple of websites that I am testing will allow the root user and password to succeed, but deny access to the users.

I have added the users to F:\xampp\phpmyadmin\config.inc.php in the same fashion as the root user listing.

i.e. $cfg['Servers'][$i]['user'] = 'myname;
$cfg['Servers'][$i]['auth_type'] = 'http'; // Authentication method (config, http or cookie based)
$cfg['Servers'][$i]['password'] = 'mypassword';
$cfg['Servers'][$i]['AllowNoPasswordRoot'] = true;

I am not sure whether the my file in F:\xampp\mysql\bin is appropriate, since it says it is for systems with <64M and min has 3GB.

Is there another config file I am missing?

Thanks

[Wiedmann]

I have added the users to F:\xampp\phpmyadmin\config.inc.php in the same fashion as the root user listing.

MySQL users must be added to MySQL and not to the phpMyAdmin configuration:
--> open phpMyAdmin in your browser, go to "Privileges" and add your new users.

[johnlanglois]

Thank you for the response. I have already added them via phpMyAdmin. That's why I thought adding them in the other file might make them visible to whatever program authenticates them.

They also appear in the mysql user table. Some show localhost in the host column. Others show % (is that a wildcard?).
The passwords are there. Does it matter that max_user_connections = 0?