Error 2002 mysqld.sock 2

 

Bismillah

q> Coba

[sourcecode language="bash"]mysql -uroot -p[/sourcecode]

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

q> Cek service mysql

[sourcecode language="bash"]ps -ef | grep [/sourcecode]

q> Hasilnya :

[sourcecode language="text"]
root 1628 1 0 Sep06 ? 00:00:00 sudo mysqld --skip-grant-tables
mysql 1629 1628 0 Sep06 ? 00:00:51 mysqld --skip-grant-tables
root 14367 8293 0 14:08 pts/2 00:00:00 grep --color=auto mysql
[/sourcecode]

q> Capturenya :


q> Wow pantes ada dua service mysql yang jalan, hapus proses yang ownernya root yaitu proses no 1628

[sourcecode language="bash"]kill 1628[/sourcecode]

q> Kemudian cek lagi service mysqlnya


q> Kemudian coba lagi login ke mysqlnya

[sourcecode language="bash"]mysql -uroot -p[/sourcecode]

Alhamdulillah