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

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

am 09.03.2005 07:02:08 von Billy Pilgrim

Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these
directions:
http://dev.mysql.com/doc/mysql/en/installing-binary.html
I then logged in, changed root password, used test database, etc.

Now after reboot I cannot connect. I get this:

root@mycomputer:/usr/local/mysql/bin # ./mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket
'/tmp/mysql.sock' (2)

Please give options if this involves: manual server start, setting up
autostart, etc.
Thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

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

am 09.03.2005 09:24:58 von Gleb Paharenko

Hello.



See:

http://dev.mysql.com/doc/mysql/en/can-not-connect-to-server. html









Billy Pilgrim wrote:

> Hello, I installed MySQL 4.1.10 on Debian Ubuntu based following these

> directions:

> http://dev.mysql.com/doc/mysql/en/installing-binary.html

> I then logged in, changed root password, used test database, etc.

>

> Now after reboot I cannot connect. I get this:

>

> root@mycomputer:/usr/local/mysql/bin # ./mysql -u root -p

> Enter password:

> ERROR 2002 (HY000): Can't connect to local MySQL server through socket

> '/tmp/mysql.sock' (2)

>

> Please give options if this involves: manual server start, setting up

> autostart, etc.

> Thanks

>



--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@ensita.net
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql@m.gmane.org

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

am 27.10.2009 07:33:20 von lists

The socket hets created when you start the server
It might be in the mysql home dir, it might be in /var/run.
See if its declared in my.cnf


Sent via BlackBerry from T-Mobile

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org