[help] mysql error

Diskusi tentang Ubuntu Server baik webserver, database server, samba server dan service lainnya serta jaringan menggunakan Sistem Operasi Ubuntu.
Post Reply
User avatar
tarantul4

[help] mysql error

Post 26 Aug 2010, 12:06

muncul pesan kyk gini "ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)"

mau replikasi media wiki di localhost tp, ketika mau memasukkan isi database wiki ke mysql dengan perintah "# mysql -u mediawiki -pmediawiki mediawiki < /usr/local/src/wikidb.sql" muncul pesan kyk di atas...

webserver menggunakan lampp....

mohon bantuannya ^_^


User avatar
lisnux

Post 26 Aug 2010, 12:35

coba kalau pake perintah

Code: Select all

mysql -u user -p
bisa masuk ke mysql tidak ?

btw mau replikasi speedywiki ya :D


User avatar
didiet_file

Post 26 Aug 2010, 12:40

setau gw klo mysql shock itu file mysql server lw error bro, klo mau coba mysql -h (nama_host) -U (nama_user) -p -> enter
masukin password mysql_server_nya


User avatar
tarantul4

Post 27 Aug 2010, 13:28

wadduchh sama kaka...tetap muncul pesan "ERROR 2002 (HY000): Can�t connect to local MySQL server through socket �/var/run/mysqld/mysqld.sock� (2)"...sy sudah bikin link ke file /var/run/mysqld/mysqld.sock dgn perintah :
root@sxired-desktop:/home/sxired# mkdir /var/run/mysqld

root@sxired-desktop:/home/sxired# ln -s /opt/lampp/var/mysql/mysql.sock /var/run/mysqld/mysqld.sock

root@sxired-desktop:/home/sxired# mysql
ERROR 2002 (HY000): Can�t connect to local MySQL server through socket �/var/run/mysqld/mysqld.sock� (2)

sama kakak...sy juga udh pastikan port 3306...tidak sedang di gunakan

mohon bantuannya ^_^


Post Reply

Who is online

Users browsing this forum: No registered users and 119 guests