For users who are facing similar similar issues, there was /etc/my.cnf present which was causing an issue as MySQL by default first looks for the conf file there. So rename it or remove it to fix the issue.
Please open a ticket if you are still facing any issues.