On Wed, 26 Mar 2003 14:37:33 -0800 Jennifer Goodie wrote: > To answer the original question, I have tried a lot of different ways, but > the only solution I have found is granting on the entire database or > specifing each table in the tables_priv table. I go with the second option > because although it is more work I like only allowing as much access as > needed. The wild cards just don't seem to work in this instance. Has > anybody had any success with it?
This solution works, of course, but has one unwanted pre-requisite. I
have to be the root MySQL user (or a user that has privileges to modify
that table) to modify table_priv.
The code that I am working on will be running on a Apache server and I
do not want to have the web server login to MySQL using a user with that
high privileges. It is a security issue!! :)
I guess, I will have to work arround this!!
Thanx
-- Mitko
pgp00000.pgp
Description: PGP signature
