Schultheis Burkhard
unread,Nov 16, 2020, 1:27:15 AM11/16/20You do not have permission to delete messages in this group
Sign in to report message
Either email addresses are anonymous for this group or you need the view member email addresses permission to view the original message
to
I wanted to clean up the table mysql.user, because there were still
entries for hosts in it, which we don't have anymore. I wanted to type
something like this:
DELETE FROM mysql.user WHERE host LIKE "nn.nn.nn%";
By mistake this became
DELETE FROM mysql.user WHERE user host LIKE "nn.nn.nn%";
Caused the exact opposite of what I intended, as if I had entered
DELETE FROM mysql.user WHERE host NOT LIKE "nn.nn.nn%";
Was fatal, of course. Can anyone figure out why the wrong statement made
such a mess?
This is mariadb 10.4.14.
Greetings
Burkhard