MySQL: Check if the user exists and drop it

by

This worked for me:

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

This creates the user if it doesn’t already exist (and grants it a harmless privilege), then deletes it either way. Found solution here: http://bugs.mysql.com/bug.php?id=19166

Updates: @Hao recommends adding IDENTIFIED BY; @andreb (in comments) suggests disabling NO_AUTO_CREATE_USER.

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. How to do a batch insert in MySQL
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. Maximum number of records in a MySQL database table
  7. Swapping column values in MySQL
  8. JOIN queries vs multiple queries
  9. Is the primary key automatically indexed in MySQL?
  10. Storing Data in MySQL as JSON
  11. MySql: MyISAM vs. Inno DB! [closed]
  12. MySQL: Cloning a MySQL database on the same MySql instance
  13. DOs and DONTs for Indexes [closed]
  14. How to change the default port of mysql from 3306 to 3360
  15. How to set a MySQL row to READ-ONLY?
  16. How to insert images from database?
  17. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  18. When to use MyISAM and InnoDB? [duplicate]
  19. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  20. How to insert a file in MySQL database?
  21. How do I rename a MySQL database (change schema name)?
  22. Foreign key to one of many tables?
  23. Find date range overlaps within the same table, for specific user MySQL
  24. Rename a table in MySQL
  25. What’s the recommended way to connect to MySQL from Go? [closed]
  26. How to store Query Result in variable using mysql
  27. How to find all the relations between all mysql tables?
  28. How to speed up sql queries ? Indexes?
  29. How to reuse auto_increment values? [duplicate]
  30. MySQL: Computed Column

Leave a Comment