← Back to team overview

maria-discuss team mailing list archive

Re: clean MDB 10.4.7 install fails `mysql_upgrade` with FATAL ERROR: "Illegal mix of collations (utf8mb4_unicode_ci, COERCIBLE) and (utf8mb4_general_ci, COERCIBLE) for operation 'like'"


On 21.06.19 07:31, PGNet Dev wrote:

blind educated guess:

> 		init-connect          = 'SET NAMES utf8mb4'

init-connect is only executed for non-SUPER users

> But if I next exec `mysql_upgrade`, it FAILS with
and you're probably running mysql_upgrade as "root", or another
user with "SUPER" privileges?

Hartmut Holzgraefe - Principal Support Engineer (EMEA)
MariaDB Corporation - http://www.mariadb.com/