Broke MySql during updating to 8.0

2 posts / 0 new
Last post
#1 Mon, 11/18/2019 - 15:21

Broke MySql during updating to 8.0


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


Tue, 11/19/2019 - 03:25

Might work. - Read the bit about "caching_sha2_password Compatibility Issues and Solutions"

Topic locked