List:General Discussion« Previous MessageNext Message »
From:Daevid Vincent Date:October 14 2010 11:46pm
Subject:How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!
View as plain text  
I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
the very specific mysql.time_zone_name table?? I don't want to GRANT it to
every individual user manually, I want one single GRANT that encompasses
every user simultaneously.

I've tried all of these, and they all are valid in mySQL but none of them
actually have the desired result.

GRANT SELECT ON `mysql`.`time_zone_name` TO '%';
GRANT SELECT ON `mysql`.`time_zone_name` TO '%'@'%';
GRANT SELECT ON `mysql`.`time_zone_name` TO ''@'%';
GRANT SELECT ON `mysql`.`time_zone_name` TO '';
GRANT SELECT ON `mysql`.`time_zone_name`; (this one fails)

Here are the results:

SELECT * FROM mysql.time_zone_name LIMIT 0, 5000

Error Code : 1142
SELECT command denied to user 'daevid'@'mycompany.com' for table
'time_zone_name'

Thread
How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent15 Oct
  • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Johnny Withers15 Oct
    • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Suresh Kuna15 Oct
      • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Jesper Wisborg Krogh15 Oct
        • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent15 Oct
          • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Jesper Wisborg Krogh16 Oct
            • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!Daevid Vincent16 Oct