I am getting "Access denied for user: 'MyAdmin@<ipaddress>' to database
'mydb'" when executing
REVOKE ALL ON mydb.* FROM 'Username'@'%'
The Revoke statement is being executed via MyODBC 3.51
The following query:shows the active permissions for the user 'MyAdmin':
SELECT U.User, U.Grant_priv as User_Grant,
D.Db, D.Grant_priv as DB_Grant,
T.Table_name, T.Grantor, Table_priv
FROM user as U
INNER JOIN db as D
ON D.User = U.User
AND D.Host = U.Host
LEFT OUTER JOIN tables_priv as T
ON T.User = D.User
AND T.Host = D.Host
AND T.Db = D.Db
WHERE U.User = 'MyAdmin'
ORDER BY D.Db, T.Table_name
and it returns:
(Format as monospaced font and remove extraneous line breaks):
Host User User. Db Db. Table_name Table_priv
Grant_priv Grant_priv Grantor
-----+---------+-----------+-------+----------+-------+------+-----------
% CL.Admin N mydb Y (NULL) (NULL) (NULL)
% CL.Admin N mysql N (NULL) (NULL) (NULL)
-----+---------+-----------+-------+----------+-------+------+-----------
The MySQL documentation indicates that if the required User permission is
not set, MySQL will check the DB permission.
So why am I getting this error?
TIA,
Tore.