[+] Inicio | [+] Contacto | [+] Blog



SOLUCIÓN: ERROR 2002 (HY000): Can’t connect to local MySQL server through socket ‘/var/run/mysqld/mysqld.sock’ (2)

$ date | cat c4t3g0ry;
- - Publicado el 09/09/2014 | Esto es sobre: Unix/Linux Sys.Admin

Recientemente mi novia instalo en una Maquina virtual Kali Linux, cómo sabemos es un debian, este error ya me había salido hace muchas lunas atrás eh aquí otra solución:

[email protected]:~ mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)
[email protected]:~ mysqladmin password newpassword
mysqladmin: connect to server at 'localhost' failed
error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'
Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!
[email protected]:~ mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)

Al parar y prender nuevamente el demonio me salió un [info] el cual menciona que algunas tablas estaban corruptas:

[email protected]:~ ps ax | grep mysql
12528 pts/0    S+     0:00 grep mysql
[email protected]:~ service mysql start
[ ok ] Starting MySQL database server: mysqld ..
[info] Checking for tables which need an upgrade, are corrupt or were
not closed cleanly..
[email protected]:~ mysql -u root -p
Enter password:
ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)
[email protected]:~ /etc/init.d/mysql status
[info] /usr/bin/mysqladmin  Ver 8.42 Distrib 5.5.38, for debian-linux-gnu on x86_64
Copyright (c) 2000, 2014, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Server version          5.5.38-0+wheezy1
Protocol version        10
Connection              Localhost via UNIX socket
UNIX socket             /var/run/mysqld/mysqld.sock
Uptime:                 2 min 57 sec

Threads: 1  Questions: 576  Slow queries: 0  Opens: 421  Flush tables: 1  Open tables: 41  Queries per second avg: 3.254.

A lo cual decidí apagar el demonio de mysql y usar el script de arranque de mysql.

[email protected]:~ service mysql stop
[ ok ] Stopping MySQL database server: mysqld.
[email protected]:~ mysqld_safe --skip-grant-tables &
[1] 13184
[email protected]:~ 140908 14:45:55 mysqld_safe Logging to syslog.
140908 14:45:55 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
[email protected]:~ mysql -u root
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.38-0+wheezy1 (Debian)

Y listo… nuestro demonio de mysql corre perfectamente, ya queda la configuración de la contraseña y ciertas cosas que dependen de cada uno.

Saludos