> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 5:54 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> > Any user can get into mysql,
x27;help;' or '\h' for help. Type '\c' to clear the buffer.
(develo...@localhost) [(none)]> SELECT * FROM mysql.time_zone_name;
++--+
| Name | Time_zone_id
> -Original Message-
> From: Jesper Wisborg Krogh [mailto:jes...@noggin.com.au]
> Sent: Friday, October 15, 2010 2:33 PM
> To: MY SQL Mailing list
> Subject: Re: How do I GRANT SELECT to mysql.time_zone_name
> for ANYONE?!
>
> Hi
>
>
> On 16/10/20
ody to do a SELECT on the table, but rather
allow users logging in as the '%'@'%' user to select from the
mysql.time_zone_name table. If the users used in the above GRANT
statements don't exist, they will also end up being created. This
means that you suddenly might have opene
then flush privileges.
>
> JW
>
>
> On Thu, Oct 14, 2010 at 6:46 PM, Daevid Vincent 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
>
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 wrote:
> I'm pulling my hair out. How do I GRANT the SELECT ability to ANY USER for
> the very specific mysql.time_zone_nam
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 the
At 4:20 PM +0100 3/6/08, Andre Hübner wrote:
Hi List,
user wants to do:
SELECT COUNT(*) FROM mysql.time_zone_name;
problem ist that this table in mysql is empty. I
dont know how to fill with data. I tried on
testmachine with mysql_install_db but it leaves
empty.
Where to get sql-data to
On Thu, Mar 6, 2008 at 10:20 AM, Andre Hübner <[EMAIL PROTECTED]> wrote:
> Hi List,
>
> user wants to do:
>
> SELECT COUNT(*) FROM mysql.time_zone_name;
>
> problem ist that this table in mysql is empty. I dont know how to fill with
> data. I tried on testmachin
Hi List,
user wants to do:
SELECT COUNT(*) FROM mysql.time_zone_name;
problem ist that this table in mysql is empty. I dont know how to fill with
data. I tried on testmachine with mysql_install_db but it leaves empty.
Where to get sql-data to fill these tables in mysql-db?
Thank you
Andre
10 matches
Mail list logo
