Arch Linux

delacruz

Member

From: /home/houston

Registered: 2007-12-09

Posts: 102

[SOLVED] Error conecting to MYSQL

My mysql one day (few days ago)  just stopped working after rebooting.  I now get this error message

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

I have tried to start mysql but i get this message

$ sudo /etc/rc.d/mysqld start
:: Starting MySQL                                                        [FAIL]

any ideas?

Last edited by delacruz (2008-09-29 00:36:34)

kamituel

Member

From: Poland

Registered: 2006-09-14

Posts: 47

Website

Re: [SOLVED] Error conecting to MYSQL

You've got the first error as the result of the second one. Try maybe running MySQL from the command line, instead of running it via /etc/rc.d/ scripts. It would propably also fail, but at least you would have an opportunity to see some error messages.

---

I tried, I failed, no matter. Try again, fail again, fail better.

delacruz

Member

From: /home/houston

Registered: 2007-12-09

Posts: 102

Re: [SOLVED] Error conecting to MYSQL

when you say run mysql from the command line you mean i type mysql in the terminal right?  I have done that and i get error message

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

Last edited by delacruz (2008-09-28 17:13:49)

crouse

Arch Linux f@h Team Member

From: Iowa - USA

Registered: 2006-08-19

Posts: 907

Website

Re: [SOLVED] Error conecting to MYSQL

http://forums.mysql.com/read.php?11,27769,59865
http://alexle.net/archives/149

Last edited by crouse (2008-09-28 23:58:39)

mrbug

Member

Registered: 2007-07-17

Posts: 221

Re: [SOLVED] Error conecting to MYSQL

I had this problem the other day. Does the partition with /var/lib/mysql have any space left?

---

dvdtube - download all uploads from a YouTube user and then optionally create a DVD.
(Regular version AUR link / SVN version AUR link)

delacruz

Member

From: /home/houston

Registered: 2007-12-09

Posts: 102

Re: [SOLVED] Error conecting to MYSQL

I had this problem the other day. Does the partition with /var/lib/mysql have any space left?

i have 5.6 GB left

EDIT: i think i am missing the mysql.sock file.  How do i get it back?

EDIT: got it working now.  i did the following

chmod 755 -R /var/lib/mysql/*

then started mysql right up.

Last edited by delacruz (2008-09-29 00:36:13)