[help] mysql error

Diskusi tentang Ubuntu Server baik webserver, database server, samba server dan service lainnya serta jaringan menggunakan Sistem Operasi Ubuntu.
User avatar
tarantul4
Posts: 42
Joined: 22 Feb 2010, 10:47
Contact:

[help] mysql error

Postby tarantul4 » 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
Posts: 1763
Joined: 02 Jan 2010, 16:26
Location: Samarinda
Contact:

Re: [help] mysql error

Postby lisnux » 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
Posts: 27
Joined: 18 Aug 2010, 02:58
Location: depok

Re: [help] mysql error

Postby didiet_file » 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
sta
Posts: 2003
Joined: 27 Apr 2010, 09:49
Contact:

Re: [help] mysql error

Postby sta » 26 Aug 2010, 13:45

User avatar
tarantul4
Posts: 42
Joined: 22 Feb 2010, 10:47
Contact:

Re: [help] mysql error

Postby tarantul4 » 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 ^_^

Return to “Ubuntu Server”

Who is online

Users browsing this forum: No registered users and 4 guests