MySQL Access denied for all but root

Problems with the Windows version of XAMPP, questions, comments, and anything related.

MySQL Access denied for all but root

Postby johnlanglois » 02. March 2009 17:17

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
johnlanglois
 
Posts: 3
Joined: 02. March 2009 16:07

Re: MySQL Access denied for all but root

Postby Wiedmann » 02. March 2009 17:21

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.
Wiedmann
AF Moderator
 
Posts: 17106
Joined: 01. February 2004 12:38
Location: Stuttgart / Germany

Re: MySQL Access denied for all but root

Postby johnlanglois » 02. March 2009 17:34

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?
johnlanglois
 
Posts: 3
Joined: 02. March 2009 16:07


Return to XAMPP for Windows

Who is online

Users browsing this forum: No registered users and 53 guests