List:General Discussion« Previous MessageNext Message »
From:Martin Gainty Date:September 30 2009 1:12pm
Subject:RE: Unable To Remove User
View as plain text  
Grant

he is trying to login as that user
then drop the user he logged in as

Martin Gainty 
______________________________________________ 
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
 
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so
bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer
Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und
entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von
E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous
n'êtes pas le destinataire prévu, nous te demandons avec bonté que
pour satisfaire informez l'expéditeur. N'importe quelle diffusion non
autorisée ou la copie de ceci est interdite. Ce message sert à
l'information seulement et n'aura pas n'importe quel effet légalement obligatoire.
Étant donné que les email peuvent facilement être sujets à la
manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu
fourni.




> Date: Wed, 30 Sep 2009 22:39:50 +1000
> From: gxallen@stripped
> To: carloswill@stripped
> CC: mysql@stripped
> Subject: Re: Unable To Remove User
> 
> Carlos Williams wrote:
> > On Tue, Sep 29, 2009 at 11:36 PM, mos <mos99@stripped> wrote:
> >> Why don't you just say "Drop User carlos"?
> >> Also are you logged in as root?
> > 
> > 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';
> > command. Why can't I remove this user from MySQL?
> 
> [ snip ]
> 
> > Database changed
> > mysql> select User, Host from user;
> > +--------+------------+
> > | User   | Host       |
> > +--------+------------+
> > | carlos | localhost
> >  |
> > | root   | localhost  |
> > +--------+------------+
> > 2 rows in set (0.00 sec)
> 
> 
> Carlos, is this output exactly as it appeared when you ran the command? 
> Specifically, that extra carriage return after localhost for the user carlos?  I wonder if
> the host value is actually localhost followed by a carriage return, which is why it isn't
> found when you try to drop the user using the 'carlos'@'localhost' value.  Try this select
> statement to confirm:
> 
> select user, host from user where host = 'localhost';
> 
> If you don't see carlos returned as a user, this is potentially the problem.  If
> that's the case, use Claudio's suggestion to remove the user manually.
> 
> Ciao
> Fuzzy
> :-)
> 
> ------------------------------------------------
> Dazed and confused about technology for 20 years
> http://fuzzydata.wordpress.com/
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
 		 	   		  
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd_062009
Thread
Unable To Remove UserCarlos Williams30 Sep
  • Re: Unable To Remove Usermos30 Sep
    • Re: Unable To Remove UserCarlos Williams30 Sep
      • Re: Unable To Remove UserClaudio Nanni30 Sep
        • Re: Unable To Remove UserCarlos Williams30 Sep
      • Re: Unable To Remove UserGrant Allen30 Sep
        • RE: Unable To Remove UserMartin Gainty30 Sep
          • Re: Unable To Remove UserCarlos Williams30 Sep
            • RE: Unable To Remove UserLIU YAN30 Sep
RE: Unable To Remove UserJohn Daisley30 Sep