Can't Get Into MySQL

[Chad Harrison]

On Apr 14, 2008, at 3:00 PM, macosx-admin-request at omnigroup.com wrote:

> Message: 2
> Date: Mon, 14 Apr 2008 11:56:06 -0700
> From: m i l e s <magicmiles at gmail.com>
> Subject: Can't Get Into MySQL
> To: macosx-admin at omnigroup.com
> Message-ID: <A5F62950-0305-40EF-8D62-9ADF63850873 at gmail.com>
> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes
>
> Hi,
>
> I just opened the box of a NEW XServe, was checking out MySQL to see
> if I needed to update the version that its running and I see its been
> made part of the install. That's great. However I turned it on as a
> service, tried to login with Navicat, and a host of other tools. No
> go. The response I get back from Navicat (and every other tool) is
> that I can't connect to the host on 127.0.0.1 (61). Ummm, that's a
> standard loopback address. I should be able to connect on that IP.
> Furthermore, when I change the IP to IP of the machine, no go either.
> And yes I'm connected to the 1st Ethernet Port, not the 2nd. Ethernet1
> is up and running.
>
> Firewall is allowing ALL connections.
>
> So what am I missing ?
>
> Miles.
>
> PS: Asked this same question on the apple boards over the weekend, got
> no response.
>
> Posting here in hopes that someone can direct me to what's up with my
> XServe in relation to MySQL.  Thanks ahead of time...


The MySQL permissions table (mysql.user) my not contain an entry for  
127.0.0.1 - try localhost or the <name of your server>.local