TIL: MySQL FLUSH PRIVILEGES isn’t needed

July 17th, 2015

Warning: This post is 8 years old. Some of this information may be out of date.

The most popular post on this site, by far, is titled 'MySQL Create Database with UTF8 Character Set Syntax'. The post contained a small snippet with three MySQL commands to create the MySQL database with UTF-8 character set, grant the user privileges, and finally to Flush Privileges.

Today, Scott Lindsey pointed out in the comments that FLUSH PRIVILEGES isn't needed. After double checking locally that Scott was correct I looked it up and found a great explanation why MySQL FLUSH PRIVILEGES isn't needed on this blog post at dbahire.com

Thanks to Scott Lindsey for pointing this out.