Error 2002 mysqld.sock 2

 

Bismillah

q> Coba

mysql -uroot -p

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

ps -ef | grep 

q> Hasilnya :

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

q> Capturenya :
Selection_439

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

kill 1628

q> Kemudian cek lagi service mysqlnya
Selection_440

q> Kemudian coba lagi login ke mysqlnya

mysql -uroot -p

Alhamdulillah

 

Published by

saifiahmada

Begin a big Process with a bit trying

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s