Mysql Server always throwing unknown error
I found the answer through this post MySQL 5.7 No Longer Returns Meaningful Error Messages.
On analyzing the mysql log in the path /var/log/mysqld.log. the error was decribed as [ERROR] Can't find error-message file '/usr/share/mysql/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.