Command line wierdness
Posted: Mon Jan 14, 2008 4:02 pm
i'm on the command line and i'm trying to grant privileges to a user. normally i can do this with no issues but this is a different case that i was not aware of
i have a database with this format: databasename-suffix.
the dash it throwing it off. here are the queries that i run and the errors i get:
or this one:
one last one
i can't figure out a way around this. can i receive some help on this? thank you
i have a database with this format: databasename-suffix.
the dash it throwing it off. here are the queries that i run and the errors i get:
Code: Select all
GRANT select
ON database-name
TO me;
[[b]error[/b]]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-dev
TO me' at line 2
Code: Select all
GRANT select
ON 'database-name'
TO me;
[[b]error[/b]]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''database-name' TO me' at line 2
Code: Select all
GRANT select
ON database-name.*
TO me;
[[b]error[/b]]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-dev.*
TO me' at line 2