[ILUG] Can't grant in MySQL

[Niall O Broin]

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 .


Niall