Broke MySql during updating to 8.0

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

Broke MySql during updating to 8.0

Hi,

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

Thanks

Tue, 11/19/2019 - 03:25
Dibs
[mysqld]
default_authentication_plugin=mysql_native_password

Might work.

https://dev.mysql.com/doc/refman/8.0/en/upgrading-from-previous-series.html - Read the bit about "caching_sha2_password Compatibility Issues and Solutions"

Topic locked