From: Martin Gainty Date: September 30 2009 1:12pm Subject: RE: Unable To Remove User List-Archive: http://lists.mysql.com/mysql/218885 Message-Id: Content-Type: multipart/alternative; boundary="_1bd72867-6f62-4389-a01b-e49d153f5bb6_" --_1bd72867-6f62-4389-a01b-e49d153f5bb6_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Grant he is trying to login as that user then drop the user he logged in as Martin Gainty=20 ______________________________________________=20 Verzicht und Vertraulichkeitanmerkung/Note de d=E9ni et de confidentialit= =E9 =20 Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaeng= er sein=2C so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiter= leitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient l= ediglich dem Austausch von Informationen und entfaltet keine rechtliche Bin= dungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen w= ir keine Haftung fuer den Inhalt uebernehmen. Ce message est confidentiel et peut =EAtre privil=E9gi=E9. Si vous n'=EAtes= pas le destinataire pr=E9vu=2C nous te demandons avec bont=E9 que pour sat= isfaire informez l'exp=E9diteur. N'importe quelle diffusion non autoris=E9e= ou la copie de ceci est interdite. Ce message sert =E0 l'information seule= ment et n'aura pas n'importe quel effet l=E9galement obligatoire. =C9tant d= onn=E9 que les email peuvent facilement =EAtre sujets =E0 la manipulation= =2C nous ne pouvons accepter aucune responsabilit=E9 pour le contenu fourni= . > Date: Wed=2C 30 Sep 2009 22:39:50 +1000 > From: gxallen@stripped > To: carloswill@stripped > CC: mysql@stripped > Subject: Re: Unable To Remove User >=20 > Carlos Williams wrote: > > On Tue=2C Sep 29=2C 2009 at 11:36 PM=2C mos wrote: > >> Why don't you just say "Drop User carlos"? > >> Also are you logged in as root? > >=20 > > In my original message to the board I demonstrated the error I get on > > my server when I attempt to run the 'drop user 'carlos'@'localhost'=3B > > command. Why can't I remove this user from MySQL? >=20 > [ snip ] >=20 > > Database changed > > mysql> select User=2C Host from user=3B > > +--------+------------+ > > | User | Host | > > +--------+------------+ > > | carlos | localhost > > | > > | root | localhost | > > +--------+------------+ > > 2 rows in set (0.00 sec) >=20 >=20 > Carlos=2C is this output exactly as it appeared when you ran the command?= Specifically=2C that extra carriage return after localhost for the user c= arlos? I wonder if the host value is actually localhost followed by a carr= iage return=2C which is why it isn't found when you try to drop the user us= ing the 'carlos'@'localhost' value. Try this select statement to confirm: >=20 > select user=2C host from user where host =3D 'localhost'=3B >=20 > If you don't see carlos returned as a user=2C this is potentially the pro= blem. If that's the case=2C use Claudio's suggestion to remove the user ma= nually. >=20 > Ciao > Fuzzy > :-) >=20 > ------------------------------------------------ > Dazed and confused about technology for 20 years > http://fuzzydata.wordpress.com/ >=20 > --=20 > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dmgainty@stripped= om >=20 =0A= _________________________________________________________________=0A= Insert movie times and more without leaving Hotmail=AE.=0A= http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=3DTXT_TAGLM_WL_HM_Tut= orial_QuickAdd_062009= --_1bd72867-6f62-4389-a01b-e49d153f5bb6_--