phpmyadmin problem, and possibly mysql connect issue

I'm unable to connect to my MySQL database with phpmyadmin when:

$cfg['Servers'][$i]['host'] = 'localhost';

However, I am able to connect when I change that information to
(NewMachine1 is the hostname of the computer):

$cfg['Servers'][$i]['host'] = 'NewMachine1';

Why am I not able to connect to MySQL via localhost, but I am able to
connect when I use the actual machine name. I have tested, and I made
sure I am able to ping localhost (resolves to 127.0.0.1), and I
verified my entry in /etc/hosts:

127.0.0.1 localhost.localdomain localhost
192.168.1.5 NewMachine1.domain.dom NewMachine1

MySQL is listening on port 3306 on 0.0.0.0 (which I believe means any
IP address on the machine).

Is there something I should look for, I don't know why I'm not able to
use localhost as opposed to the actual computer name?

Re: phpmyadmin problem, and possibly mysql connect issue

On 1 Jan 2007 13:37:02 -0800, "Mike" wrote:

>I'm unable to connect to my MySQL database with phpmyadmin when:
[snip]
>Is there something I should look for, I don't know why I'm not able to
>use localhost as opposed to the actual computer name?

IIRC this one caught me out too. It's down to MySQL Privileges, not
PhpMyAdmin I think.

When you allow access to a db (using the hosts column of the mysql.db
table) from *any* IP address - i.e. "%" - that does NOT include
localhost.
--
Locate your Mobile phone:
Great gifts:

Re: phpmyadmin problem, and possibly mysql connect issue

David Quinton wrote:
> On 1 Jan 2007 13:37:02 -0800, "Mike" wrote:
>
> >I'm unable to connect to my MySQL database with phpmyadmin when:
> [snip]
> >Is there something I should look for, I don't know why I'm not able to
> >use localhost as opposed to the actual computer name?
>
> IIRC this one caught me out too. It's down to MySQL Privileges, not
> PhpMyAdmin I think.
>
> When you allow access to a db (using the hosts column of the mysql.db
> table) from *any* IP address - i.e. "%" - that does NOT include
> localhost.
> --

I do have permissions setup in MySQL for user root@localhost, and not
just root@%. The odd thing that is occurring, is that in phpmyadmin,
that it says unable to connect to server, check to ensure that your
socket connection is setup properly, and the second I change that host
line to the local machine name, it works.

I'm not getting the error about an improper login name or password, it
is actually reporting that it is unable to connect.

Thanks

Mike

Re: phpmyadmin problem, and possibly mysql connect issue

On 2 Jan 2007 02:42:26 -0800, "Mike" wrote:

>I'm not getting the error about an improper login name or password, it
>is actually reporting that it is unable to connect.

OK. Sorry!
--
Locate your Mobile phone:
Great gifts:

Re: phpmyadmin problem, and possibly mysql connect issue

David Quinton wrote:
> On 2 Jan 2007 02:42:26 -0800, "Mike" wrote:
>
> >I'm not getting the error about an improper login name or password, it
> >is actually reporting that it is unable to connect.
>
> OK. Sorry!
> --


I hope what I said didn't come off as being rude. . . I was just simply
replying to your previous statement.

Thanks

Mike

Re: phpmyadmin problem, and possibly mysql connect issue

On 2 Jan 2007 07:43:07 -0800, "Mike" wrote:

>I hope what I said didn't come off as being rude. . . I was just simply
>replying to your previous statement.

Not in the sllightest, Mike.
Problem with Usenet is that one can GUARANTEE that there's always
someone out there who knows far more about any subject. And I'm very
aware how easy it is to make a pratt of oneself. So I always apologise
profusely!
--
Locate your Mobile phone:
Great gifts: