First of all you have an eroneus update statement:
UPDATE SET activ = 'inactiv' WHERE ident = 'fai'
After UPDATE the tablename must be pesent
UPDATE `tble_name` SET activ = 'inactiv' WHERE ident = 'fai'
Now next in line...
REVOKE all ON fai_accounts FROM 'fai'@'mydom.tld'
You are revoking user 'fai' from host 'mydom.tld' at database
'fai_accounts'... but this has nothing to do with
show grants for current_user()
Because that will show the grant 'source' for the current user that I think
is not 'fai' but 'root' as you output says...
To see grants for 'fai'@'mydom.tld' you should use:
SHOW GRANTS FOR 'fai'@'mydom.tld'
Hope it helps !
Gabriel PREDA
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
