"ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)" di XAMPP server

Kemarin install MYSQL Server pakai paket XAMPP. Terus seting privileges dari phpmyadmin mysql. (http://server/phpmyadmin)


Tapi saat masuk mysql server dari localhost (pakai terminal), saat ketik
# mysql -u root -p

keluar error "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)"

Setelah googling akhirnya ketemu cara untuk mem-fixnya.
Langkahnya:

#su
#mkdir /var/lib/mysql
#cd /var/lib/mysql
#ln -s /opt/lampp/var/mysql/mysql.sock

This will allow you to use tools such as mysql-query-browser without any hassles.

To access mysql from the command line:

#/opt/lampp/bin/mysql -u root -p


beres...