Unable to update - have update priveledge

[LarrySteele]

I've been granded update priveledge to tables in a few databases on our server: Select_priv ,Insert_priv, Update_priv, Delete_priv, Create_priv, Drop_priv, References_priv, Index_priv, Alter_priv, Create_tmp_table_priv, and Lock_tables_priv are all set to 'Y' for a selected database.

I can connnect and read the data and data definitions just fine. I cannot insert, update, delete, create, or alter any table in this database.

Our admin worked for a couple of hours yesterday trying to resolve the issue, but no joy. I've googled for this problem and the most relavent posts I've found were problems related with users not being able to connect. I can connect and I can read, I just can't do any of the other priviledges.

Any suggestions on what we might check for, or where we might be able to find relavent information?

Thanks in advance,
Larry

 

[ericbrunson]

Did you try this?

grant all on yourdatabase.* to yourusername@yourmachinename

This is the prefered way to grant.

If not, did you remember to 'flush privileges' after updating the privilege tables?

 

[LarrySteele]

Thank you for the suggestion.

Yes, that's the syntax he used, and he did flush.

It seemed nothing he did had any effect on my priviledges, except when I had him revoke for a database. Then the database was gone. As soon as he granted me full access, it was available, but I was back to read-only.

I do have other mysql databases that I am able to edit - both data and definion. Priviledges are identical.

Thanks again,
Larry