2009/5/27 Daevid Vincent
>
> Wondering which of these will work or not?
>
> (no quotes)
> GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY
> PASSWORD 'secret';
>
> (backticks)
> GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED
> BY PASSWORD 'secr
On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent wrote:
> So why mySQL is putting back ticks in there even though I didn't,
Because it doesn't save your original statements, but recreates an
appropriate set from the grant tables.
> and more importantly why doesn't the second line say:
Becaus
ntly why doesn't the second line say:
>
> GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD
> 'secret';
>
> like the first line says and like I specifically said in my grant statement
> up above??!
>
> -Original
the second line say:
GRANT ALL PRIVILEGES ON mydb.* TO 'user'@'10.10.10.%' IDENTIFIED BY PASSWORD
'secret';
like the first line says and like I specifically said in my grant statement
up above??!
-----Original Message-
From: Daevid Vincent [mailto:dae...@daevid.c
Wondering which of these will work or not?
(no quotes)
GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED BY
PASSWORD 'secret';
(backticks)
GRANT ALL PRIVILEGES ON `mydb`.`mytable` TO 'user'@'10.10.10.%' IDENTIFIED
BY PASSWORD 'secret';
(single quotes)
GRANT ALL PRIVILEGES O
