[ILUG] Can't grant in MySQL
Niall O Broin
niall at linux.ie
Fri Jun 17 13:28:55 IST 2005
On 17 Jun 2005, at 12:10, Gareth Eason wrote:
> - Go into the database server using the mysql client.
> - type "use mysql;"
> - use SQL to set permissions as appropriate.
> - type "flush privileges;"
> - job done.
> MySQL has a long history of the GRANT command not working with quite
> the Ronseal factor required. (i.e. It doesn't really do what it says on
> the tin.)
> Just edit the privs in the priv database (mysql), remember that the
> privs are NOT live until you do a 'flush privileges' and off you go :-)
Ah, I think the GRANT command works more or less now (though I'm long
enough using MySQL to rmemeber when the GRANT command was a no-op). As
you could see from the SHOW GRANT command given, the user 'boss' had
ALL privileges, including GRANT, and the mysql.user table showed that
too. Nonetheless, there is something he hasn't got, because SHOW GRANT
shows the individual privileges (all of them) rather than ALL .
More information about the ILUG