You can try

delete from mysql.user
where user='mail_admin'
   and host like '\%' ;

Note: I haven't tested it and since % is a wildcard you need to escape it.
Best,
Shiv

On Thu, Dec 1, 2011 at 6:09 PM, Tim Dunphy <bluethu...@jokefire.com> wrote:

> 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
>
>

Reply via email to