Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

Can't connect to local MySQL server through socket '/var/mysql/mysql.sock' (2) LEOPARD

Post by JRoug » Wed, 30 Dec 2009 09:22:21


I got this error starting mysql from installation:
sh-3.2# /usr/local/mysql/bin/mysql -user=mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/var/mysql/mysql.sock' (2)
The same goes for starting as root.

I do the
sh-3.2# find ~ -name mysql.sock on my home directory,
find . -name mysql.sock in the /usr/local directory and,
find / -name mysql.sock and don't get a response.

I haven't gotten the mysqld started once from the installation.
I removed the other installations.

MY.CONF:
[client]
socket=/var/mysql/mysql.sock

PHP.INI
; Default socket name for local MySQL connects. If empty, uses the
built-in
; MySQL defaults.
mysql.default_socket = /var/mysql/mysql.sock


The entire MY.CONF
[mysqld]
#Path to installation directory. All paths are usually resolved
relative to this.
basedir=/usr/local/mysql-5.1.40-osx10.5-powerpc/bin/
#Path to the database root
datadir=/usr/local/mysql-5.1.40-osx10.5-powerpc/data
#Path to the temporary directory.
tmpdir=/private/tmp
#The size of the buffer used for index blocks. Increase this to get
better index handling (for all reads and multiple writes) to as much
as you can afford; 64M on a 256M machine that mainly runs MySQL is
quite common.
key_buffer_size=8192k
#Each thread that needs to do a sort allocates a buffer of this size.
sort_buffer_size=2M
#If no specific storage engine/table type is defined in an SQL-Create
statement the default type will be used.
default-storage-engine=myisam
[client]
socket=/var/mysql/mysql.sock

Why does it think there are two mysql.sock?
thanks,