/tmp/socket (2) error on freebsd

Posted on 2005-03-17
Medium Priority
Last Modified: 2012-06-27
I facing with this problem ERROR 2002: Can't connect to local MySQL server through socket '/tmp/mysql.socket' (2).

I am using FreeBSD5.3, apache1.3, php4 and mysql 4.0.3
i go through with all the forum and documentation but failed to solve...

please help
Question by:operation1611
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
LVL 33

Expert Comment

ID: 13568485
Is the mysqld service running?

Accepted Solution

jnielsendotnet earned 200 total points
ID: 13568688
How did you install MySQL?  Is it running?  What command are you issuing that gives you that error?

If you installed MySQL from the ports/packages system, you should be able to startt mysqld by giving the 'start' parameter to its startup script:

/usr/local/etc/rc.d/mysql-server.sh start

If it's a recent revision of the port, then you will need to have
in your /etc/rc.conf for the script to do  anything.

Also, note that the default socket is "/tmp/mysql.sock" (and not mysql.socket, as you wrote).

Finally, I would recommend updating to MySQL 4.1.10 from ports or packages.  You should plan on dumping/restoring your data if you want to preserve it across the upgrade.


Author Comment

ID: 13568744
thank you...after i upgrade, everything works fine

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Containers like Docker and Rocket are getting more popular every day. In my conversations with customers, they consistently ask what containers are and how they can use them in their environment. If you’re as curious as most people, read on. . .
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question