> I would want to verify that the mysql.sock is actually in /tmp/ folder.
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -h 127.0.0.1 -u
root -p
Enter password:
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -h 127.0.0.1 -u
mysql
ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (61)
I don't understand this mysql.sock when does it get installed at start
up or when mysql is installed? Maybe I should change the my.conf and
the php.ini to be /var/msyql/mysql.sock to see if it works. I looked
in there and don't see a file named mysql.sock. I also looked in /
tmp/ and there is no file called mysql.sock.
php.ini:
mysql.default_socket= /tmp/mysql.sock
My.conf :
[client]
socket=/tmp/mysql.sock
>> The far more likely answer is that the mysql isn't up and running.
>>
>> How did you start the server? Manually or automatically as a part of
>> startup?
I put the com.mysql.mysqld.plist from HiveLogic in /Library/
LaunchDaemons,
http://www.yqcomputer.com/
the instructions are for compiled mysql with snow leopard but I only
used the plist instructions:
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ launchctl load -w /
Library/LaunchDaemons/com.mysql.mysqld.plist
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -uroot
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -u root
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
janis-roughs-power-mac-g5:LaunchDaemons jlrough$ mysql -u _mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)
That was what the launchd was all about. It was from the plist.
>>
>>>> Should I reinstall mysql yet again? hat will be painful since I
>>>> really don't know what is wrong.
>>>> Janis
>>
>> I don't think so. See the above for possible troubleshooting steps.
Thanks,