/tmp in server was not allowing any write on it causing mysql to fail
below is the solution to fix it
Stop all services using /tmp using below command
systemctl stop httpd
systemctl stop mysql
systemctl stop cpanel
umount -f /var/tmp
rm -fv /usr/tmpDSK
/scripts/securetmp
The /tmp is recreated and all services are working fine