MySQL: When is Flush Privileges in MySQL really needed?

by

Privileges assigned through GRANT option do not need FLUSH PRIVILEGES to take effect – MySQL server will notice these changes and reload the grant tables immediately.

From MySQL documentation:

If you modify the grant tables directly using statements such as
INSERT, UPDATE, or DELETE, your changes have no effect on privilege
checking until you either restart the server or tell it to reload the
tables. If you change the grant tables directly but forget to reload
them, your changes have no effect until you restart the server. This
may leave you wondering why your changes seem to make no difference!

To tell the server to reload the grant tables, perform a
flush-privileges operation. This can be done by issuing a FLUSH
PRIVILEGES statement or by executing a mysqladmin flush-privileges or
mysqladmin reload command.

If you modify the grant tables indirectly using account-management
statements such as GRANT, REVOKE, SET PASSWORD, or RENAME USER, the
server notices these changes and loads the grant tables into memory
again immediately.

More Related Contents:

  1. Can we use CONCAT and JOIN together in MySQL? [closed]
  2. how to generate report for attendance system
  3. MySQL pivot table query with dynamic columns
  4. Finding duplicate values in MySQL
  5. Error installing mysql2: Failed to build gem native extension
  6. How to debug Lock wait timeout exceeded on MySQL?
  7. CROSS/OUTER APPLY in MySQL
  8. How to extract two consecutive digits from a text field in MySQL?
  9. Connect By Prior Equivalent for MySQL
  10. How to send email from MySQL 5.1
  11. Import Data from Excel Spreadsheet or CVS into MySQL
  12. How to convert all tables from MyISAM into InnoDB?
  13. How can I get rid of these comments in a MySQL dump?
  14. How to create relationships in MySQL
  15. MySQL error 1436: Thread stack overrun, with simple query
  16. int(11) vs. int(anything else)
  17. ALTER TABLE to add a composite primary key
  18. MySQL Removing Some Foreign keys
  19. node.js + mysql connection pooling
  20. MySQL password function
  21. How can I enable MySQL’s slow query log without restarting MySQL?
  22. How to select the most recent set of dated records from a mysql table
  23. MySQL database with unique fields ignored ending spaces
  24. Does MySQL allows to create database with dot?
  25. Second SELECT query if first SELECT returns 0 rows
  26. Selecting multiple columns/fields in MySQL subquery
  27. How to rearrange MySQL columns?
  28. Trouble with GROUP_CONCAT and Longtext in MySQL
  29. How to pass a variable to a IN clause?
  30. Insert and set value with max()+1 problems

Leave a Comment