recover from failed mysql upgrade (5.6 to 5.7)

i updated mysql using the tool provided in WHM. all seemed to run smoothly until it tried to restart mysql and i got this message:

tried to reboot and restart services (old windows habits 🙂 ) and of course it didn’t work.

so i opened up a ssh connection, deleted all content from /etc/my.cnf and replaced it with:

restarted mysql again (with success) and then deleted once again all content from /etc/my.cnf and restarted mysql

went back to whm – Upgrade MySQL and clicked on Resume Upgrade button

just to be sure i went back to ssh and ran

all good after that 😀