Home > Blogosphere > Can’t start Mysql server : Bind on unix socket: Permission denied On FreeBSD

Can’t start Mysql server : Bind on unix socket: Permission denied On FreeBSD


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.

Kejadian ini dimungkinkan karena miss kom pada saat bersih bersih direkrori kemarin hehehe.

groups# /usr/local/etc/rc.d/mysql-server start
mysql already running? (pid=5278).
groups#
  1. No comments yet.
  1. No trackbacks yet.

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

%d bloggers like this: