Developer Forum

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

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

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,

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

4. Seen this message? Can't connect to local MySQL server through socket '/tmp/mysql.sock'

5. Warning: mysql_connect(): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) in /home/custcare/dbconn.inc on line 2

6. Reading Error: socket '/var/lib/mysql/mysql.sock'

7. ERROR 2003 (HY000): Can't connect to MySQL server on 'localhost' (10061)

8. Can't connect '/var/lib/mysql/mysql.sock' (13) - but not the usual suspects

9. Can't connect '/var/lib/mysql/mysql.sock' (13) - but not the usual suspects???

10. ERROR 2013 (HY000): Lost connection to MySQL server during query

11. ERROR 2006 (HY000): MySQL server has gone away

12. Using Python and Connecting to MySQL remotely WITHOUT MySQL installed on local computer

13. connecting to local mySQL using MySQL Administrator

14. Unable to connect with local MySql thru Dreamweaver 8