drop user in MySQL

Am 20. Aug, 2003 schw=E4tzte Joe Toon so:

> > I can just delete the appropriate rows, but I'd rather use the user
> > manager
> > interface.
>
> I tried this in phpMyAdmin and I looked in the MySQL docs, it appears tha=
t
> you need to modify the table directly. phpMyAdmin does the following:
>
> # Deleting 'fred'@'%' ...
> DELETE FROM `user` WHERE `User` =3D "fred" AND `Host` =3D "%";
> DELETE FROM `db` WHERE `User` =3D "fred" AND `Host` =3D "%";
> DELETE FROM `tables_priv` WHERE `User` =3D "fred" AND `Host` =3D "%";
> DELETE FROM `columns_priv` WHERE `User` =3D "fred" AND `Host` =3D "%";
>
> # Reloading the privileges ...
> FLUSH PRIVILEGES ;
>
> If you find another way, please post to this thread. :)

That worked. The box didn't catch fire. Must be OK. :)

I'm thinking a shell script with a for loop is hte way I'll go next time.

danke,

der.hans
--=20
#  https://www.LuftHans.com/    http://www.AZOTO.org/
#  "... the social skills of a cow on acid." - der.hans