maria-discuss team mailing list archive

Thread
Date

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'"

To: pgnet.dev@xxxxxxxxx, maria-discuss@xxxxxxxxxxxxxxxxxxx
From: Hartmut Holzgraefe <hartmut@xxxxxxxxxxx>
Date: Fri, 21 Jun 2019 11:13:24 +0200
In-reply-to: <71806bbe-d8ad-e95d-5070-684e1bca8262@gmail.com>
User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.6.1

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/

References

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'"
From: PGNet Dev, 2019-06-21