I runned this in mysql:

UPDATE db SET Insert_priv='Y', Create_priv='Y' WHERE Db='wordpress_fixed';

But this not preventing from inserting more data to database wordpress_fixed. Is it supposed to work that way?

  • 1
    Direct granting privilege (setting it to 'Y') kills preventing for according action (after flushing, of course). If you want to revoke some privilege directly you must set according parameter to 'N' value...
    – Akina
    Mar 28, 2019 at 5:27

1 Answer 1


If you manually update any mysql.X table regarding privileges will require a FLUSH PRIVILEGES to effect the change.

Using GRANT is the better way of of ensuring privs exists (and doesn't require FLUSH PRIVILEGES).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.