Posted by Mike on 01/02/07 10:42

David Quinton wrote:
> On 1 Jan 2007 13:37:02 -0800, "Mike" <mikedawg@gmail.com> 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

[Back to original message]