If MySQL seems to "forget" privileges ...

2014-07-04 | #mysql, #solution

Make sure, that you use a unique name@host combination for every grant. MySQL saves the password per user, not per schema, not per table or privilege or somehow per grant, but only per DB-user. Granting new privileges on an existing user, also providing a password, overwrites the old password and therefore "deletes" privileges granted before.

So remember to check msql.user before adding privileges for a "new" user.