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" <prajapatikc@stripped>
To: "Tim Dunphy" <bluethundr@stripped>
Cc: mysql@stripped
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 < 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
