| 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 Vincent | 15 Oct |
| • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Johnny Withers | 15 Oct |
| • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Suresh Kuna | 15 Oct |
| • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Jesper Wisborg Krogh | 15 Oct |
| • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Daevid Vincent | 15 Oct |
| • Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Jesper Wisborg Krogh | 16 Oct |
| • RE: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?! | Daevid Vincent | 16 Oct |
