1

Hi when i enter:GRANT ALL PRIVILEGES ON . TO 'yourusername'@'localhost' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION; I get:The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement. What should i do to off skip-grant-tables option? Thanks.

Improve this question

1 Answer 1

Reset to default
2

Check mysql configs in /etc/mysql/ or the runscript in /etc/init.d/ .

Edit:
Try this: GRANT ALL, GRANT OPTION ON . TO user@localhost;

http://dev.mysql.com/doc/refman/5.1/en/grant.html

Improve this answer
2
  • What should I check?
    – Ben
    May 19, 2010 at 18:50
  • Oh sorry the vm have been fixed now. Will report soon.
    – Apache
    May 19, 2010 at 20:26

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .