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/
