List:General Discussion« Previous MessageNext Message »
From:John Daisley Date:September 30 2009 12:51pm
Subject:RE: Unable To Remove User
View as plain text  
What version of mysql a you using? Drop user works differently for versions before 5.0.2.

You could just remove the user from the mysql.user table with a delete statement.


John Daisley
Mobile +44(0)7812 451238
Email john@stripped

Certified MySQL 5 Database Administrator (CMDBA)
Certified MySQL 5 Developer
Cognos BI Developer

Sent from HP IPAQ mobile device.

-----Original Message-----
From: Carlos Williams <carloswill@stripped>
Sent: Wednesday, September 30, 2009 12:47 PM
To: mysql@stripped
Subject: Re: Unable To Remove User

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

[The entire original message is not included]
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