This website is deprecated, and remains online only for historic access to old issues and docs for historic versions of Virtualmin. It has been unmaintained for several years, and should not be relied on for up-to-date information. Please visit www.virtualmin.com instead.

Broke MySql during updating to 8.0

2 posts / 0 new

Topic locked

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

#2 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