MySql #2002 problem
- by Systeem Faillure
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.
