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:
- The mysql socket is properly defined in the MySQL configuration file - /etc/my.cnf
cat /etc/my.cnf [mysqld] socket=/tmp/mysql.sock
- Then restart the MySQL server
- Now the socket file must /tmp/mysql.sock exists
ls -la /tmp/mysql.sock srwxrwxrwx 1 mysql mysql 0 Sep 26 06:20 /tmp/mysql.sock=