On Thu, Oct 25, 2012 at 10:40 PM, Richard Toohey < richardtoo...@paradise.net.nz> wrote:
> On 10/26/12 09:35, Tony Berth wrote: > >> Dear group, >> >> I'm trying to run phpMyAdmin on a 5.1 box (i386) with MySQL 5.1.60 >> installed from the OpenBSD packages. >> >> When I try to login I get: >> >> #2002 Cannot log in to the MySQL server >> >> Please note that the same mysql user is able to login remotely via the >> MySQL GUI workbench! >> >> Now, I came across the following posting: >> >> http://marc.info/?l=openbsd-**misc&m=116902953505548&w=2<http://marc.info/?l=openbsd-misc&m=116902953505548&w=2> >> >> and did apply the suggested solution but didn't work! >> >> I also have to mention that my sock file is located in: >> >> /var/run/mysql/mysql.sock >> >> could that be a problem with the chrooted apache? >> >> Thanks >> >> T >> >> >> chrooted Apache might not be able to resolve localhost, so you can try > fixing that, or use 127.0.0.1 instead of localhost. You *may* also have to > grant privileges to the user@127.0.0.1, but first just try changing the > phpMyAdmin to point to 127.0.0.1. > > Not replying to the list because I haven't got my asbestos pants on today. > correct! That indeed was the problem. Replacing localhost with 127.0.0.1 did work. Thanks a lot T
