DBDivaAuto
IS-IT--Management
I have a MySql db on an external server where we will be putting an Intranet Site. I have 30 tables built out all under the site /db admin login ID. I finally got to where I only had permissions errors. Did some research and found an article re: the Information_Schema DB and the table SCHEMA_PRIVILEGES.
Now the only grantee is my admin account. The Is_Grantable is set to NO and needs to be YES so that SELECTS, UPDATES, INSERTS and DELETES can work.
I wrote a simple update to SET Is_Grantable to 'YES' WHERE Is_Grantable = 'NO ' and it says my admin account doesn't have privileges to change the table.
So how in the HECK does one change the table when HELLO you have to be able to look up and write to the tables?
Now the only grantee is my admin account. The Is_Grantable is set to NO and needs to be YES so that SELECTS, UPDATES, INSERTS and DELETES can work.
I wrote a simple update to SET Is_Grantable to 'YES' WHERE Is_Grantable = 'NO ' and it says my admin account doesn't have privileges to change the table.
So how in the HECK does one change the table when HELLO you have to be able to look up and write to the tables?