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. Can't connect '/var/lib/mysql/mysql.sock' (13) - but not the usual suspects

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

9. SN#23067 MySQL Server 5.1.46 and MySQL 5.5.4

10. Mac OS X keeps deleting my /tmp files (mysql.sock)

11. connecting to local mySQL using MySQL Administrator

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

13. Mac OS X keeps deleting my /tmp files (mysql.sock)

14. Unable to connect with local MySql thru Dreamweaver 8