Я нашел следующее в/etc/mysql/my.cnf:
# Instead of skip-networking the default is now to listen only on
# localhost which is more compatible and is not less secure.
bind-address = 127.0.0.1
Для решения моей проблемы я сделал две вещи:
Теперь это работает.
This was a great example of super Type error I did. So guys anybody who is struggling just look at my question and main problem was calling syslog_ng rather than syslog_ng::config at the node level. I know this is super stupid but happens.