addon_securityadvisor icon indicating copy to clipboard operation
addon_securityadvisor copied to clipboard

Anonymous MySQL users command needs to accommodate ANSI_QUOTES

Open FGasper opened this issue 10 years ago • 0 comments

mysql -e 'drop user ""'

The above, according to the docs, will fail if ANSI_QUOTES is enabled. (cf. https://dev.mysql.com/doc/refman/5.6/en/string-literals.html)

It should work to change it to:

mysql -e "drop user ''"

FGasper avatar Aug 29 '13 19:08 FGasper