From: Claudio Nanni
Date: September 30 2009 12:18pm
Subject: Re: Unable To Remove User
List-Archive: http://lists.mysql.com/mysql/218882
Message-Id: <53bcf3a60909300518l43aa3396l69b61f36dccf673b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative; boundary=001485e9ab4ff849e50474ca88ef

--001485e9ab4ff849e50474ca88ef
Content-Type: text/plain; charset=ISO-8859-1

Remove manually (delete) the user from all the privilege tables:

delete from columns_priv where user='carlos';
delete from db where user='carlos';
delete from procs_priv where user='carlos';
delete from tables_priv where user='carlos';
delete from user where user='carlos';

then a nice FLUSH PRIVILEGES;

this should fix, let me know!

Claudio

2009/9/30 Carlos Williams <carloswill@stripped>

> 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? I am logged in as
> root on both Linux and MySQL so I don't see why I can't remove
> 'carlos'@'localhost'. It's as if MySQL doesn't understand this user
> exist. He might not exist because I can't login as him however I need
> this entry removed from the "user" table.
>
> [root@tiger ~]# mysql -u root -p
> Enter password:
> Welcome to the MySQL monitor.  Commands end with ; or \g.
> Your MySQL connection id is 9
> Server version: 5.1.38 Source distribution
>
> mysql> show grants for 'carlos'@'localhost';
> ERROR 1141 (42000): There is no such grant defined for user 'carlos'
> on host 'localhost'
> mysql> use mysql;
> Reading table information for completion of table and column names
> You can turn off this feature to get a quicker startup with -A
>
> Database changed
> mysql> select User, Host from user;
> +--------+------------+
> | User   | Host       |
> +--------+------------+
> | carlos | localhost
>  |
> | root   | localhost  |
> +--------+------------+
> 2 rows in set (0.00 sec)
>
> mysql> drop user 'carlos'@'localhost';
> ERROR 1396 (HY000): Operation DROP USER failed for 'carlos'@'localhost'
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.nanni@stripped
>
>


-- 
Claudio

--001485e9ab4ff849e50474ca88ef--