TIL: MySQL FLUSH PRIVILEGES isn’t needed


Posted by Andrew McCombe on Fri Jul 17, 2015

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.