On 8/11/2004, "Richard Lewis" richardlewis@fastmail.co.uk wrote:
On Sun, 7 Nov 2004 15:01:06 +0000, "Chris Green" chris@areti.co.uk said:
On Sun, Nov 07, 2004 at 12:17:26AM -0000, Mark Rogers wrote:
Now that I think more about this, I recall that "any host" specifically excludes "localhost". As a general rule, just think of localhost and other hosts separately.
Ah, yes, I think that would explain what I'm seeing, thanks. I do want to have the 'Any Host' access as this is on a small home network and I want to allow other computers to access that database. It's behind a NAT firewall so the outside world won't be able to see it.
I'm sure you know this already, but:
PHP runs locally so only needs privileges for 'localhost', its only if your running a MySQL client on another machine on the network that it needs to have privileges for a host other than 'localhost' (whether this be the default MySQL client or any other client software you may write).
You will also need to make sure that the line 'skip-networking' in /etc/mysql/my.cnf is commented out otherwise your privileges settings for hosts other than localhost will be useless ;-)
Cheers, Richard
Just a heads up if you're running Mandrake. This is from their security list and it sounds like you may have hit this problem:-
"I am currently running my mail and web server on MDK 9.2 which is kept "up to the minute" with all of the latest updates and patches advised on this list. I am running 4 sites (virtual hosting) using mySQL. Up until now I have never had a problem administering the mySQL databases with webmin or phpMyAdmin but suddenly after the update, I can no longer "see" the databases - only the one called test. The databases are still there and they are still functioning but I cannot now administer them. My usual username and password returns #1045 - Access denied with phpMyAdmin and webmin tells me there are no databases other than test.
What has changed to cause this - I need to do some work urgently. The databases cannot be accessed either remotely or locally."
Matt