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
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
/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