List:General Discussion« Previous MessageNext Message »
From:Claudio Nanni Date:December 2 2011 8:59pm
Subject:Re: delete syntax
View as plain text  
2011/12/2 Reindl Harald <h.reindl@stripped>

> 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
>
> The privileges should be maintained  only using the designated commands.
You cannot rely on the knowledge you have of the underlying implementation
which can change anytime , while the privileges command are standard.

*Cheers*

Claudio Nanni


> 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.reindl@stripped
> >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
>
>


-- 
Claudio

Thread
delete syntaxTim Dunphy2 Dec
  • Re: delete syntaxKrishna Chandra Prajapati2 Dec
    • Re: delete syntaxTim Dunphy2 Dec
      • Re: delete syntaxShiva2 Dec
        • Re: delete syntaxReindl Harald2 Dec
          • Re: delete syntaxStdranwl2 Dec
            • Re: delete syntaxReindl Harald2 Dec
              • Re: delete syntaxClaudio Nanni2 Dec
                • Re: delete syntaxReindl Harald2 Dec
                  • Re: delete syntaxGovinda2 Dec
                    • How to get a specific number of entries per one key ?Blog Tieng Viet3 Dec
                      • Re: How to get a specific number of entries per one key ?Arthur Fuller3 Dec
                        • Re: How to get a specific number of entries per one key ?Rik Wasmus5 Dec
    • Re: delete syntaxKeith Keller2 Dec