Re: delete syntax

[Krishna Chandra Prajapati]

delete from mysql.user where user='mail_admin';

Krishna

On Fri, Dec 2, 2011 at 7:23 AM, Tim Dunphy <bluethundr@stripped> 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
>
>