MySQL Socket

From Wiki

Jump to: navigation, search

Question

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

Answer

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
[mysqld]
socket=/tmp/mysql.sock
/etc/init.d/mysql restart
ls -la /tmp/mysql.sock
srwxrwxrwx 1 mysql mysql 0 Sep 26 06:20 /tmp/mysql.sock=
Personal tools
Namespaces
Variants
Actions
Navigation
Toolbox