[Wolves] Destitute MySQL

[Wayne Morris]

Andrew Lewis wrote:

> Got a bit of a strange one here..... The answer is probably obvious, 
> but I just don't get it.
>
> I'm running a LAMP on FC3, and for some reason my mysql server won't 
> connect on localhost, but it will connect on the actual IP of the 
> machine (192.168.0.199)
> Am I just thick, or is this just strange. I've more or less removed, 
> updated and reinstalled all the AMP bit of LAMP, but to no avail. My 
> hosts file looks OK, and everything seems to work otherwise.
>
> I've worked around the problem, but I don't get why I should have to 
> give the machine address instead of localhost. The machine is sitting 
> behind an IPCOP, so there are no iptables or anything that could 
> interfere. I'm willing to let it work like this until I reinstall, but 
> I just need to know WTF it thinks it's doing so I can get some sleep.
>
> Ideas?
> Ms
>
> _______________________________________________
> Wolves LUG mailing list
> Homepage: http://www.wolveslug.org.uk/
> Mailing list: Wolves at mailman.lug.org.uk
> Mailing list home: http://mailman.lug.org.uk/mailman/listinfo/wolves


Mysql has variuos permissions for who can connect from where, ie you can 
set that root can only connect from localhost , from another server or both
This looks usefull
http://www.databasejournal.com/features/mysql/article.php/3311731