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
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
