Hello Krishna, Thanks but I probably should have noted that I only want to delete the wildcard user. There are other users I would prefer to not delete.
mysql> select user,host from mysql.user where user='mail_admin'; +------------+-----------------------+ | user | host | +------------+-----------------------+ | mail_admin | % | | mail_admin | 127.0.0.1 | | mail_admin | localhost | | mail_admin | localhost.localdomain | +------------+-----------------------+ 4 rows in set (0.00 sec) sorry for not including enough information last time. best tim ----- Original Message ----- From: "Krishna Chandra Prajapati" <prajapat...@gmail.com> To: "Tim Dunphy" <bluethu...@jokefire.com> Cc: mysql@lists.mysql.com Sent: Thursday, December 1, 2011 9:03:46 PM Subject: Re: delete syntax delete from mysql.user where user='mail_admin'; Krishna On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy < bluethu...@jokefire.com > wrote: hello list, I am attempting to delete a user from the mysql.user table without success. mysql> delete from mysql.user where user='mail_admin@%'; Query OK, 0 rows affected (0.00 sec) mysql> select user,host from mysql.user where user='mail_admin'; +------------+-----------------------+ | user | host | +------------+-----------------------+ | mail_admin | % | I would appreciate any advice you may have. Regards, Tim -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
