Niall O Broin wrote:
> On 16 Jun 2005, at 18:11, Niall Walsh wrote:
>>>> mysql> show grants for boss at some.mysql.server \G
>>> *************************** 1. row ***************************
>>> Grants for boss at some.mysql.server: GRANT SELECT, INSERT, UPDATE,
>>> DELETE, CREATE, DROP, RELOAD, SHUTDOWN, PROCESS, FILE, REFERENCES,
>>> INDEX, ALTER ON *.* TO 'boss'@'some.mysql.server' IDENTIFIED BY
>>> PASSWORD '1a2154e5660c6374' WITH GRANT OPTION
>>> 1 row in set (0.00 sec)
>>>>>> but yet I can't grant access to a database:
>>>>> That's because you don't have grant rights!
>>> What part of "WITH GRANT OPTION" did you not see in the above list?
Emm ... the part where it said "WITH GRANT OPTION" at the END of the
above list ... and looking over your mails there were plenty of other
indications! Seemed to hit a mental blind spot somehow ...
Sorry :-)
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!
