I have attempted to run the grant line many a time, but to no avail. Is there some setting that I must reset before I am able to successfully grant myself the privilages to use my database?
Code:
mysql> grant all privilages on *.* to 'some_user'@localhost identified by 'some_pass' with grant option;
ERROR 1064 (42000): You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax near 'privilages on *.* to 'some_user'@localhost identified by 'some_pass' with grant option' at line 1
of course, for security purposes, I substituted 'some_user' and 'some_pass' for my username and password. this has been the same message i've gotten every time I've used the grant command. no dice.
any advice? i knew that SQL was picky, but obviously it in league with my system is lord king of picky. i can't seem to resolve this problem...