Re: Error 1535 | Table definition on master and slave does not match

[Rick James]

A non-replicated ALTER TABLE would be the fix, if it were just VARCHAR size. However, since it is a data encoding difference, there could be worse issues.

Do you have any rows with any non-ascii characters? Accented characters exist in both latin1 and utf8, but their encodings are different.

If it is all ascii, then a non-replicated ALTER should work (I guess).

If you have some non-ascii chars, then find out what you have in each machine, then we can discuss what to do.

Meanwhile, read
http://mysql.rjweb.org/doc.php/charcoll
for more insight. Note especially the SELECT HEX() suggestion.