On Mon, Nov 08, 2004 at 09:58:30AM +0000, Richard Lewis 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).
I 'knew' it in the sense that if I'd thought about it I would have know it! :-)
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 ;-)
OK, thanks.