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