2009/5/27 Daevid Vincent dae...@daevid.com
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
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
and like I specifically said in my grant statement
up above??!
-Original Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Tuesday, May 26, 2009 4:49 PM
To: 'mysql@lists.mysql.com'
Subject: GRANT and ticks or no ticks...
Wondering which of these will work or not?
(no quotes
Message-
From: Daevid Vincent [mailto:dae...@daevid.com]
Sent: Tuesday, May 26, 2009 4:49 PM
To: 'mysql@lists.mysql.com'
Subject: GRANT and ticks or no ticks...
Wondering which of these will work or not?
(no quotes)
GRANT ALL PRIVILEGES ON mydb.mytable TO 'user'@'10.10.10.%' IDENTIFIED
On Wed, May 27, 2009 at 2:05 AM, Daevid Vincent dae...@daevid.com 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