I think this is one of those times you would update the mysql.user table directly, then flush privileges.
JW On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent <dae...@daevid.com> wrote: > 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' > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql?unsub=joh...@pixelated.net > > -- ----------------------------- Johnny Withers 601.209.4985 joh...@pixelated.net
