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 Peter H. C » Wed, 30 Dec 2009 09:30:27



Where are you starting the server? "mysql" including
"/usr/local/mysql/bin/mysql" are the CLIENT. "mysqld" (and its assorted
wrappers including mysqld_safe) are the server. Need both.

--
86. I will make sure that my doomsday device is up to code and properly
grounded.
--Peter Anspach's list of things to do as an Evil Overlord
 
 
 

1. ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock'

2. 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock'(46)


It sounds as though you've made a mess of things. Presumably if you're
using WinMySQLAdmin, you're on Windows, although I've only ever come
across the socket problem on Mac OS X or Linux.

One thing you can try is this (assuming you're on Windows):

Open a Windows Command Prompt window
Type the following commands:

cd c:\mysql\bin
mysqladmin -p -u root -h 127.0.0.1 shutdown

Enter your MySQL root password when prompted.

That should close down MySQL. You can then try restarting it.

If that doesn't work, you should completely uninstall MySQL and start
all over again.

--
David Powers
Author, "Foundation PHP 5 for Flash" (friends of ED)
Co-author "PHP Web Development with DW MX 2004" (Apress)
http://www.yqcomputer.com/

3. 2002 Can't connect to local MySQL server through socket '/tmp/mysql.sock'(46)

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

5. connecting to local mySQL using MySQL Administrator

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

7. mysql and mysql.sock

8. I want to make transfer data between MySQL Server to MySQL Local .

9. mailing.database.mysql-internals, mailing.database.mysql, mailing.database.mysql-java, comp.lang.java.programmer

10. Unable to connect with local MySql thru Dreamweaver 8

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

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

13. SN#21100 MySQL News Bites - January 7th Webinar, New MySQL Community Blog, Zack Urlocker on 5.1, Tutorial on MySQL and NetBeans 6.5, MySQL Migration Toolkit, MySQL Conference & Expo

14. Can't connect to MySQL-MySQL messed up