Apparently you have to manually edit sites.json to change the version of MySQL, cause it can’t open it because of a mysql.sock error. Probably because the old one doesn’t even work anymore, it can’t find the libraries, I installed one I thought it was missing, didn’t fix shit.
You can find that file in “~/.config/Local”.
If you have any working sites, you can get the working MySQL version from it, or look in “~/.config/Local/lightning-services/”.
Maybe it’s because I restored a backup. Maybe move the folder to .bak, open Local, and then restore only the data you need.
I had to figure that out myself, their forum is useless.
You may have to open a site terminal and run wp db repair. Or just try starting the site again.