TIL: MySQL FLUSH PRIVILEGES isn’t needed
July 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
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.