From: Reindl Harald
Date: December 2 2011 9:31pm
Subject: Re: delete syntax
List-Archive: http://lists.mysql.com/mysql/226431
Message-Id: <4ED943AA.80104@thelounge.net>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
 protocol="application/pgp-signature";
 boundary="------------enig4A749E1F1D774812E5E27B39"

--------------enig4A749E1F1D774812E5E27B39
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable



Am 02.12.2011 21:59, schrieb Claudio Nanni:
> 2011/12/2 Reindl Harald <h.reindl@stripped>
>=20
>> 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 command=
s.
> You cannot rely on the knowledge you have of the underlying implementat=
ion
> which can change anytime , while the privileges command are standard.

do what you think is good for you if YOU can't be sure what you do
there where i work i test updates and look at the user-tables
and that is why i fixed problems where root did not have the
right permissions after upgrade to 5.1 what was not corrected
with "mysql_upgrade" an rolled out without any problems

the same way i currently roll out fedora 15 on 24 production
servers because i know what i do and have the infrastructure
to prepare such major-upgrades to do them finally live after
all tests are successfull and the local cach- and internal-repos
are filled

so please do not tell other peopole on what knowledge they can rely


--------------enig4A749E1F1D774812E5E27B39
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: OpenPGP digital signature
Content-Disposition: attachment; filename="signature.asc"

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iEYEARECAAYFAk7ZQ6sACgkQhmBjz394AnksPgCfcVvaToK/4pidoc7xKFP+1DIU
a8kAn217HDtDQ1HXnbTipr+dCAoPqnTQ
=iK6y
-----END PGP SIGNATURE-----

--------------enig4A749E1F1D774812E5E27B39--