I wanted to upgrade mysql from 5.7 to 8 because of a React App I'm hosting. React App itself is working fine but my main website and roundcube email frontend is not working. During package updates mysqld always throws error and re-installing roundcube throws error of
Database connection failed : mysql::execute_sql failed : DBI connect failed : Authentication plugin 'sha256_password' reported error: Authentication requires SSL encryption 1477.
I can list my new databases on virtualmin panel but clearly it's broken at the moment. What should i do to keep mysql 8 or reinstall as mysql 5.7 to fix all issues for now
I will also supply additional info or output if needed