On Mon, Nov 24, 2008 at 03:32:56PM +0000, Mark Rogers wrote:
As I understand it, confirmed here[1], MySQL interprets "localhost" and "127.0.0.1" differently; the former uses Unix sockets if available where the latter uses TCP/IP.
That ought not affect the privileges, as far as I know, but it might have some bearing that I can't think of?
Yes, it's confusing to say the least though. I don't really understand where the three entries in the mysql users table even come from, I didn't put them there explicitly but I always seem to end up with three entries for the mySql root/superuser for 127.0.0.1, for localhost and for chris (which is the name of the machine).
Also, what does /etc/hosts have for 127.0.0.1? Some distros used to have localhost.localdomain rather than localhost, and changing them to localhost has been known to assist[2]
Ubuntu 8.10 seems to set it to:-
127.0.0.1 localhost