MySQL Forums
Forum List  »  Newbie

Re: Granting access
Posted by: Russell Dyer
Date: June 27, 2005 03:16PM

I entered the GRANT statement you show in your third posting on my server and it works (not through PHPAdmin):

GRANT ALL PRIVILEGES ON * . * TO 'steven'@'%' IDENTIFIED BY 'password' WITH GRANT OPTION;

Your error message, though, has oddities in it:

"SQL syntax near 'mysql > GRANT ALL PRIVILEGES ON * . * TO 'steven'@ '%' IDENTIFIED BY 'p' at line 1"

Are you typing "mysql >"? I shouldn't see that in the message. Also, are you putting spaces around the dot, as in "* . *"? There shouldn't be any. Try copying and pasting just the grant statement as I've copied it here. It should work.

Russell Dyer

Author of "MySQL in a Nutshell" (O'Reilly 2005).

Options: ReplyQuote


Subject
Written By
Posted
June 27, 2005 03:19AM
June 27, 2005 11:58AM
June 27, 2005 12:39PM
June 27, 2005 02:36PM
June 27, 2005 02:55PM
Re: Granting access
June 27, 2005 03:16PM
June 27, 2005 04:11PM
June 28, 2005 12:22PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.