MySQL Forums
Forum List  »  Newbie

Re: remote access and privilages
Posted by: Rick James
Date: January 20, 2009 10:52PM

root does not have permission to GRANT -- "ALL" does not include that.

GRANT ALL ON *.* TO 'user'@'host' WITH GRANT OPTION;

If no on else has root perm, restart mysql with --skip-grant-tables in order to get back in.

Options: ReplyQuote


Subject
Written By
Posted
January 19, 2009 11:52AM
Re: remote access and privilages
January 20, 2009 10:52PM


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.