well, i am using delete/insert-statements since 10 years to maintain users since you only have to know the tables in the database "mysql" and use "flush privileges" after changes
DROP USER is the only SINGLE COMMAND as long as you do not use table/column-privileges there are exactly two relevant tables: "user" and "db" Am 02.12.2011 05:15, schrieb Stdranwl: > DROP USER command is the only command to remove any user and its > association from all other tables..... > > On Fri, Dec 2, 2011 at 8:22 AM, Reindl Harald <h.rei...@thelounge.net>wrote: > >> ALWAYS >> start with "select * from mysql.user where user='mail_admin' and host like >> '\%';" >> and look what records are affected to make sure the were-statement works as >> expected and then use "CURSOR UP" and edit the last command to "delete >> from" >> >> not only doing this while unsure with escapes protects you against logical >> mistakes like forget a "and column=1" and get "1000 rows affected" with no >> way back
signature.asc
Description: OpenPGP digital signature