LinuxQuestions.org
Share your knowledge at the LQ Wiki.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices

Reply
 
Search this Thread
Old 06-08-2006, 04:01 PM   #1
Braynid
Member
 
Registered: May 2006
Location: Romania
Distribution: CentOS
Posts: 140

Rep: Reputation: 15
ERROR 1290 (HY000): The MySQL server is running with the --skip-grant-tables option s


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.

Thanks.

P.S: I looked both on google and in man mysql but couldn't figure it out.
 
Old 06-08-2006, 08:14 PM   #2
Farrukh Fida
Member
 
Registered: Jun 2006
Location: Dubai
Distribution: Cent OS
Posts: 34

Rep: Reputation: 15
Quote:
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.

Thanks.

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

mysql>exit
Bye
and restart the mysql

]# service mysqld restart


For tutorial and all basic info visit the following link
http://www.linuxhomenetworking.com/w..._Configuration
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysq mimique Linux - Software 23 08-14-2012 06:14 AM
Error with MySQL Grant Command for other users JockVSJock Slackware 9 02-19-2006 03:37 PM
fatal error : can not open privilege tables mysql.host jayakrishnan Linux - Software 3 10-11-2005 08:49 AM
Updating MySQL grant tables... sigep739 Linux - Newbie 2 01-03-2004 11:57 PM
help! mysql --skip-grant-options not working linuxquestionsu Linux - Software 3 10-15-2003 07:56 PM


All times are GMT -5. The time now is 08:02 PM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration