Comments - CREATE USER
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
If you access the privilege tables directly (as in your DELETE FROM statement), you need to flush the privileges. If you don't (as in your CREATE USER statements), you don't. Rather don't access the privilege tables directly, instead use DROP USER.