Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

up vote 2 down vote accepted

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

share|improve this answer
    
What should I check? –  Yosef May 19 '10 at 18:50
    
Oh sorry the vm have been fixed now. Will report soon. –  Shiki May 19 '10 at 20:26
    
Check edit...... –  Shiki May 19 '10 at 21:01

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.