List:General Discussion« Previous MessageNext Message »
From:Suresh Kuna Date:October 15 2010 2:47pm
Subject:Re: How do I GRANT SELECT to mysql.time_zone_name for ANYONE?!
View as plain text  
Hey Daevid,

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.
>
> 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
>



-- 
Thanks
Suresh Kuna
MySQL DBA

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