Originally Posted by Braynid
Ok this should be a really short one... when i try to create a user for cacti it gives me that error (ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option so it cannot execute this statement).
How can i disable --skip-grant-tables ? I have Ubuntu 6.06 RC server.
P.S: I looked both on google and in man mysql but couldn't figure it out.
I think u used the following command
# service mysqld stop
Stopping MySQL: [ OK ]
and u run this command
mysqld_safe --skip-grant-tables --skip-networking &
due to this command u can change uor previous root passwd so when u try to create new user u should stop above command
so exit from mysql
and restart the mysql
]# service mysqld restart
For tutorial and all basic info visit the following link