cannot connect to local MySQL through sockets

Nicolas Pavillon nicos_pavlov at
Thu Aug 11 08:01:23 PDT 2011


I assume that you recursively changed the ownership of /opt/local to root. In this case, one problem could be that the database folder of mysql5 (/opt/local/var/db/mysql5) must have the ownership of the user _mysql, group _mysql, as implied by the database installation command that is used after installing mysql5-server, and given at installation:

* In order to setup the database, you might want to run
* sudo -u _mysql mysql_install_db5
* if this is a new install



On Aug 11, 2011, at 4:03 PM, Nisar Ahmed wrote:

> Dear Members,
> I have installed PHP MySQL and Apache through macports and I did it successfully at first attempt, made some changes later and now mysql client cannot connect to server using /opt/local/var/run/mysql5/mysqld.sock.
> I changed owner ship of /opt/local folder to my local account and later realized it was a mistake so reverted back its ownership to root, but I am still facing this issue. Can anyone help me with that. I cannot find mysqld.sock in the /opt/local/var/run/mysql5 folder anymore
> Thanks
> Nisar
> _______________________________________________
> macports-users mailing list
> macports-users at

More information about the macports-users mailing list