up vote 0 down vote favorite
share [g+] share [fb]

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.

link|improve this question
94% accept rate
feedback

1 Answer

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

link|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
feedback

Your Answer

 
or
required, but never shown
discard

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