From: Daevid Vincent
Date: October 14 2010 11:46pm
Subject: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!
List-Archive: http://lists.mysql.com/mysql/223333
Message-Id:
MIME-Version: 1.0
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit
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'