Fix: Errno 3502, no GRANT or GRANT compatible permit exists
Tuesday, November 3, 2009
aka, UCOSP: status report #12
Here is a piece of php code that I ran to check I can execute query under my web server.
There it prints this error message:
no GRANT or GRANT compatible permit exists
Reason:
By default, when you create a database, the access to the database is public.
By default, when you create a table/view/procedure the access is restricted to the owner.
You will need to do "grant select on the_table/view/procedure_you_want to public". For convenience, I did "grant all on test" and ran the code above. Remember you will NEED TO log off the database where that table is sitting in order for the above code to work :)
Posted byA nerdy girl at 10:32 AM
Labels: 3502, no GRANT or GRANT compatible permit exists, status report, UCOSP
0 comments:
Subscribe to:
Post Comments (Atom)