[Wylug-help] MySQL GRANT Command

[Stephen Patterson]

On 25 Apr 07, Aaron Crane (wylug at aaroncrane.co.uk) wrote:
> I think that what you want to do is either impossible with the GRANT
> command, or possible only in MySQL 5.0 and above (and I happen to know that
> you aren't using MySQL 5.0 in this case).
> 
> You have several rows in the mysql.User table, for compo at localhost,
> compo at pub, compo at field, etc.  Each existing mysql.db, mysql.tables_priv,
> mysql.columns_priv row grants permissions to any compo@'%' user.  (Note
> that there is no meaningful way of joining mysql.db against mysql.user
> using only the equality operator.)

If I remember right (don't have mysql anywhere handy) you can also set
permissions on mysql by editing the tables in database 'mysql' directly.
Its documented but not officially approved and you need to remember to
instruct mysql to reload its permissions into memory from the database
(flush grants).

Its been years since I touched mysql, but I hope this helps a bit.

-- 
Stephen Patterson :: steve at patter.mine.nu :: http://patter.mine.nu/
GPG: B416F0DE :: Jabber: patter at jabber.earth.li 
"Don't be silly, Minnie. Who'd be walking round these cliffs with a gas oven?"
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: Digital signature
Url : http://list.wylug.org.uk/pipermail/wylug-help/attachments/20070425/4f2c609b/attachment.bin