cannot connect to local MySQL through sockets

[Nicolas Pavillon]

Hello, 

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
******************************************************

Cheers,

Nicolas


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 lists.macosforge.org
> http://lists.macosforge.org/mailman/listinfo.cgi/macports-users