List:General Discussion« Previous MessageNext Message »
From:Johnny Withers Date:October 15 2010 2:27pm
Subject:Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!
View as plain text  
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 <daevid@stripped> 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=1
>
>


-- 
-----------------------------
Johnny Withers
601.209.4985
johnny@stripped

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