Very Computer

by **Alex Soroki** » Sat, 21 Jul 2001 11:14:02

Very intresting.. i just installed mysql on my freebsd box, and tried to run
the server file... then i get this message
"ERROR 2002: Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)"

i checked the /tmp directory and their IS no mysql.sock file... opinions?
comments anyone? thanks

by **Lee Ha** » Sat, 21 Jul 2001 12:13:46

> Very intresting.. i just installed mysql on my freebsd box, and tried to run
> the server file... then i get this message
> "ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)"

Are you sure you are running the server and not the client? What is the
name of the program you are running? This sounds like the message the
client would give if the server were not running.

I believe the name of the server is mysqld (not mysql) but I think
you usually run it through some kind of wrapper.

Did you install from a port or package?

Did it not install a startup script in /usr/local/etc/rc.d ?
If it did, either run that, or check it for how to start the server.

by **DaDeXTe** » Sat, 21 Jul 2001 12:31:31

run safe_mysqld& and try it again... this will happen if you installed it from the source (as opposed to the ports collection) or if let's say you didn't reboot since the installation and the startup script located in /usr/local/etc/rc.d wasn't executed

Hope this helps

DaDeXTeR

> Very intresting.. i just installed mysql on my freebsd box, and tried to run
> the server file... then i get this message
> "ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)"

> i checked the /tmp directory and their IS no mysql.sock file... opinions?
> comments anyone? thanks

by **mic..** » Sat, 21 Jul 2001 17:38:49

> Very intresting.. i just installed mysql on my freebsd box, and tried to run
> the server file... then i get this message
> "ERROR 2002: Can't connect to local MySQL server through socket
> '/tmp/mysql.sock' (2)"

You have some periodic script or xdm script which cleans /tmp
and removes the mysql soket (happened to me!). So you need to
kill mysql and restart it.

Quote:> i checked the /tmp directory and their IS no mysql.sock file... opinions?
> comments anyone? thanks

--
Michel Talon

Very Computer

mysql problem

mysql problem

mysql problem

mysql problem

mysql problem