MySQL Socket

From Wiki

Revision as of 20:36, 2 October 2011 by Hackman (Talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search


After I installed Hive, all MySQL connections appear to be blocked even though MySQL is showing as up?


The most probable reason for this issue is that the MySQL socket file is missing or incorrectly defined in the MySQL configuration. In order for 1H software to work the mysql socket should be /tmp/mysql.sock and this should be reflected in the configuration. This is a change we make upon software installation and we create a symlink from the old socket in case it is different from the one required by 1H software.

If MySQL connections are being blocked on your server, most probably the setup was changed after the installation.

To fix the problem you should make sure that:

cat /etc/my.cnf
/etc/init.d/mysql restart
ls -la /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Sep 26 06:20 /tmp/mysql.sock=
Personal tools