Anyone has issue with MySQL 8.0?
It seems there is a jump from version 5.x to version 8.x
My fingers were itchy. I tried to change the OS in my VPS to other images (Debian 11 and Ubuntu 20.04) and tried to rebuild the server. Apache2 and PHP are fine but MySQL 8 setup seems to change. I can't login with adminer. After hours of troubleshooting, I tried to restore the image and then my VPS is down. After waiting the hosting support to check on it for 16 hours, now they restored my image which is Ubuntu 18.04.
It seems there is a jump from version 5.x to version 8.x
My fingers were itchy. I tried to change the OS in my VPS to other images (Debian 11 and Ubuntu 20.04) and tried to rebuild the server. Apache2 and PHP are fine but MySQL 8 setup seems to change. I can't login with adminer. After hours of troubleshooting, I tried to restore the image and then my VPS is down. After waiting the hosting support to check on it for 16 hours, now they restored my image which is Ubuntu 18.04.