I was trying to allocate a new user and I typed something like: grant all privileges on pail to [EMAIL PROTECTED] identified by 'hill';
I realized I made a mistake needing to specify (at least) 'pail.*', intending to grant the user access to a database I created. So to clean up I tried: revoke all privileges on mysql.pail from jill; ERROR 1141: There is no such grant defined for user 'jill' on host '%' In the privilege tables there is an entry for the user in 'user' and an entry in 'tables_priv'. Nothing any where else. The entries look reasonable (to me). In user: all privileges='N'; In pail: Table_priv: Select,Insert,Update,Delete,Create,Drop,References,Index,Alter I assume this is my error and I can remove the two entries manually but I would like to know what I am doing wrong. _____ Douglas Denault [EMAIL PROTECTED] Voice: 301-469-8766 Fax: 301-469-0601 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
