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
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.
; Default socket name for local MySQL connects. If empty, uses the
; MySQL defaults.
mysql.default_socket = /var/mysql/mysql.sock
The entire MY.CONF
#Path to installation directory. All paths are usually resolved
relative to this.
#Path to the database root
#Path to the temporary directory.
#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
#Each thread that needs to do a sort allocates a buffer of this size.
#If no specific storage engine/table type is defined in an SQL-Create
statement the default type will be used.
Why does it think there are two mysql.sock?