As this time zone table won't change once it is set up. Do a copy of the
table data into another database and give grants to it.
On Fri, Oct 15, 2010 at 7:57 PM, Johnny Withers <johnny@stripped>wrote:
> I think this is one of those times you would update the mysql.user table
> directly, then flush privileges.
> On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent <daevid@stripped> wrote:
> > I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER
> > the very specific mysql.time_zone_name table?? I don't want to GRANT it
> > 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'
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> Johnny Withers