MySql #2002 problem

Posted by Systeem Faillure on Ask Ubuntu See other posts from Ask Ubuntu or by Systeem Faillure
Published on 2012-11-05T21:02:14Z Indexed on 2012/11/05 23:19 UTC
Read the original article Hit count: 424

Filed under:
|
|
|
|

when i try to login in apache i get #2002 error. when i try to login via terminal it ask my password mysql -u root

and i get

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

i tried to remove mysql and install it again and nothing happen ( i cant even remove it) i try to reboot apache but still nothing. i tried to reboot my pc and of course still aint working.

in terminal i put sudo start mysql i got this:

start: Job failed to start

mysql -ubob -hlocalhost -P3306 -p got me this

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

sudo service mysql stop gave me this

stop: Unknown instance:

my.cnf

* Basic Settings

#

user = mysql

pid-file = /var/run/mysqld/mysqld.pid

socket = /var/run/mysqld/mysqld.sock

port = 3306

basedir = /usr

datadir = /var/lib/mysql

tmpdir = /tmp

lc-messages-dir = /usr/share/mysql

skip-external-locking

#

i tried to find if there is a file in my /var/run/mysqld/ or in /var/tmp/ and dint find the file mysqld.sock .. i looked in /var/log/mysql/ and dont even have anything in it

can help me???i try to find help on google for hours and dint help at all...

-------EDIT---------- salem :

sudo service mysql start

i get

start: Job failed to start

cat /var/log/syslog | grep mysql

here

http://paste.ubuntu.com/1335984/

/var/run/mysqld/ this folder exist but it dosent have anything in it

/var/run/mysqld/ i get

total 0 drwxr-xr-x 2 mysql root 40 Nov 5 22:31 . drwxr-xr-x 25 root root 860 Nov 5 22:32 ..

sorry that i post anything my terminal gives but i am noob at this. hope this information will do.

© Ask Ubuntu or respective owner

Related posts about files

Related posts about apache