get around not having if exists to add users in an init script mysql #db #mysql #learned on Noopsi

get around not having "if exists" to add users in an init script mysql #db #mysql #learned

"A good workaround is to grant a harmless privilege to the user before dropping it.  This
will create the user if it doesn't exist, so that it can be dropped safely, like so:

   GRANT USAGE ON *.* TO 'username'@'localhost';
   DROP USER 'username'@'localhost';
"

via: http://bugs.mysql.com/bug.php?id=19166

Feedback