Carlos Williams wrote:
On Tue, Sep 29, 2009 at 11:36 PM, mos <mo...@fastmail.fm> 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=arch...@jab.org
