In the past, when you exported the mysql.user table
you would see all of the information that you were
exporting. Now I see it's in new format that doesn't
allow you to read it and determine which ones that you
want to copy.
I assume this was added to High ASCII character sets,
but is there any way of adding a flag that allows us to
see the old version?
Most people take their permissions from one server, but
go through the list and determine which ones need to
actually be on a new server. We do this everytime we
copy the user data from one server to another.
The current system just doesn't make sense, since
MySQL itself doesn't even return the data in that format.