jemieJoomla! Apprentice Posts: 23Joined: Sun Jun 18, 2006 10:29 pmContact: Website by jemie » Wed Mar 12, 2008 9:00 am dari pesan error yang Anda kasih, sepertinya bukan pada script joomla Anda, tapi lebih ke arah sisi server. sepertinya service mysql nya sedang macet, perlu direstart servicenya. Code: ini pesan dari mysqld yang artinya gagal login. tolong dicek lagi apakah database username, database hostname, database name, dan database password sudah benar sesuai pada waktu create database? atau mungkin ada yang mau tambahin ? thanks.hackjoomJoomla! Apprentice by hackjoom » Thu May 29, 2008 7:30 pm Sedikit sumbang saran....... As I understand the question, you are trying to access mysql through web ssh in Linux php app service, but getting this error: ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2) Could you please try modifying bind-address to localhost and restart, if this helps.
Modify: bind-address = 127.0.0.1 bind-address = localhost and restart: sudo /etc/init.d/mysql restart Another option is if your file my.cnf (usually in the /etc/mysql/ folder) is correctly configured with: Tiba tiba ada keluhan http://www.unila.ac.id tidak bisa dibuka, setelah check n ricek ternyata daemon mysql-server tidak berjalan, buru buru deh masuk ke console untuk melihat ada apakah gerangan. groups# /usr/local/etc/rc.d/mysql-server start bolak balik dijalankan ternyata tidak bisa juga, haduh kenapa lagi ini, berlanjut pada pengecekan log starting mysql ternyata ditemukan log sbb. 110728 10:31:29 mysqld_safe mysqld from pid file /usr/local/mysql/groups.unila.ac.id.pid ended 110728 10:35:02 mysqld_safe Starting mysqld daemon with databases from /usr/local/mysql 110728 10:35:02 [Warning] '--skip-locking' is deprecated and will be removed in a future release. Please use '--skip-external-locking' instead. 110728 10:35:02 [Note] Plugin 'FEDERATED' is disabled. 110728 10:35:02 InnoDB: Started; log sequence number 0 136217857 110728 10:35:02 [ERROR] Can't start server : Bind on unix socket: Permission denied 110728 10:35:02 [ERROR] Do you already have another mysqld server running on socket: /tmp/mysql.sock ? 110728 10:35:02 [ERROR] Aborting 110728 10:35:02 InnoDB: Starting shutdown... 110728 10:35:07 InnoDB: Shutdown completed; log sequence number 0 136217857 110728 10:35:07 [Note] /usr/local/libexec/mysqld: Shutdown complete 110728 10:35:07 mysqld_safe mysqld from pid file /usr/local/mysql/groups.unila.ac.id.pid ended Ternyata si mysql tidak bisa membuka socket untuk menjalankan service mysql ini, ok deh kalau gitu kita lihat lagi kepemilikan mysql.sock di direktori /tmp hadah ternyata CHMOD folder /tmp berubah menjadi 755 bukan menjadi 1777 sip, ketauan masalahnya tinggal ubah mode direktorinya saja, dan selesai.. mysql dapat berjalan normal kembali. |