List:General Discussion« Previous MessageNext Message »
From:Jan Steinman Date:January 16 2012 4:35pm
Subject:Re: delete all hosts using a wildcard
View as plain text  
> From: Tim Dunphy <bluethundr@stripped>
> ... this is just a test environment so getting rid of those users won't have any
> meaningful impact...

I think what Paul (who wrote a book on MySQL, by the way) was getting at was that you risk
what database folk call "referential integrity issues" if you mess with *any* data without
knowing where else it is used.

But this has a bigger impact than if you mess up referential integrity on your own tables.
It could be that MySQL is making certain assumptions -- such as a `user` record WILL be
available if referenced in some other privilege grant -- that will break things badly,
making such tables (or functions, or procs, etc.) unreachable. This could turn into a very
confusing "learning opportunity" where changing one thing has far-reaching unintended
impact. Or it may not, if you don't have other privileges defined, in which case you may
have "learned" the false assurance that you can get away with such a thing.

I've had the former "learning experience" -- that messing with privilege tables directly
resulted in strange behaviour that ended with me trashing the entire thing and
re-installing from scratch.

My rule-of-thumb: if MySQL gives you a facility for manipulating system-level tables, just
use it! :-)


:::: Jan Steinman, EcoReality Co-op ::::

delete all hosts using a wildcardTim Dunphy14 Jan
  • Re: delete all hosts using a wildcardPaul DuBois14 Jan
    • Re: delete all hosts using a wildcardTim Dunphy15 Jan
      • Re: delete all hosts using a wildcardClaudio Nanni16 Jan
Re: delete all hosts using a wildcardJan Steinman16 Jan
  • Re: delete all hosts using a wildcardGovinda16 Jan