Re: REVOKE GRANT OPTION - is that possible?

> # mysqlmgr add database www1 > # mysqlmgr add user www1 password xxx > # mysqlmgr allow user www1 database www1 read write define I suppose in some cases this is OK, and I'm sure you will test thoroughly! :-) One thing to bear in mind is that if you define a user and then revoke his

Re: REVOKE GRANT OPTION - is that possible?

On 02.01.2006 13:41 (+0100), Imran Chaudhry wrote: > GRANT and REVOKE are essential to your database security, I would > think twice before adding a "layer" on top of them. There is potential > for error and you dont want that where security is related. It is > probably worth the "pain" of learning

Re: REVOKE GRANT OPTION - is that possible?

Yes, and from database and table level too, but you must revoke GRANT OPTION seperately from all other privs like this: REVOKE GRANT OPTION ON .FROM user GRANT and REVOKE are essential to your database security, I would think twice before adding a "layer" on top of them. There is potential for er

Re: REVOKE GRANT OPTION - is that possible?

> How can I revoke a GRANT OPTION on a database or table from a user? > > The manual says > something about > > REVOKE ALL PRIVILEGES, GRANT OPTION FROM user [, user] ... > > but this can only revoke the GRANT OPTION on a global level as it

REVOKE GRANT OPTION - is that possible?

Hi, I'm currently creating a PHP commandline tool to manage MySQL databases and user privileges easily since the whole thing is way to complex to do it by hand with SQL queries and you have nothing else right after installing the MySQL server on an SSH-only machine where the webserver depends on t