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.
Subject
Written By
Posted
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.