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


I'm not clear on why root/superuser would NOT be functional here; that doesn't make a lot of sense to me.  I need to read up further about that.

And I note the proposed 'skip' workaround ... but isn't it just that -- a workaround, around an existing 'problem'?

Do note from my OP, the existing/installed charset/collation for the 4 initialized DBs

| information_schema | CREATE DATABASE `information_schema` /*!40100 DEFAULT CHARACTER SET utf8                               */ |
| mysql              | CREATE DATABASE `mysql`              /*!40100 DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci */ |
| performance_schema | CREATE DATABASE `performance_schema` /*!40100 DEFAULT CHARACTER SET utf8                               */ |
| test               | CREATE DATABASE `test`               /*!40100 DEFAULT CHARACTER SET latin1                             */ |

Given the config in my.cnf already defined at time of 1st data initialization, it seems that that's an initial problem, no?

Shouldn't the initialization result be all charset/collation 'correctly' set, as specified?

Also,  noting in the errant script


posted fyi here,


you can see the numerous

	... COLLATE utf8_general_ci ...

(as well as a couple of ... COLLATE utf8_bin ...)

which I'd guess are causing those ERRORs I see.

Follow ups