LinuxQuestions.org
Help answer threads with 0 replies.
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 10-04-2012, 07:07 AM   #16
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655

I agree. Mysqld is a daemon and should be running in the background.

What distro do you use? Use ckconfig to enable services for the proper run levels for RPM distros like Redhat. You may also have a GUI config program where yiu can do it as well.

Undo what you did for the guest user. Giving "guest" root rights without a password sound like a horror story sys admins tell be the campfire.

Also download the manual for mysql. It lists tasks you need to perform after installation, such as giving the mysql root user a password, and dropping the demo tables.
 
Old 10-04-2012, 11:05 AM   #17
gopinathnatarajan
LQ Newbie
 
Registered: Sep 2012
Location: Bangalore
Distribution: Red Hat, CentOs
Posts: 16
Blog Entries: 1

Rep: Reputation: Disabled
try it

#sudo mysqld

edit the file inside as

% guest ALL=(ALL) NOPASSWD: (ALL)

then restart the mysqld.

sudo /etc/init.d/mysqld restart

no need to stop and start the mysqld just restart it.
 
Old 10-06-2012, 01:01 PM   #18
zak100
Member
 
Registered: Jul 2009
Posts: 224

Original Poster
Rep: Reputation: 2
Hi,
Thanks for your guidance. I would check it on Monday.
Zulfi.
 
Old 10-08-2012, 02:43 AM   #19
zak100
Member
 
Registered: Jul 2009
Posts: 224

Original Poster
Rep: Reputation: 2
Hi,
I am still trying.

Zulfi.

Last edited by zak100; 10-08-2012 at 02:45 AM.
 
Old 10-08-2012, 03:45 AM   #20
zak100
Member
 
Registered: Jul 2009
Posts: 224

Original Poster
Rep: Reputation: 2
Hi,
Thanks all of you who helped me with this problem. Its working. I tried on several computers but not on all. However, on RedHAt based computers i am getting some problem with service command. I have to check this again and let you people know if there is any problem. Otherwise I would declare this thread as solved.

Zulfi.
 
Old 10-08-2012, 11:22 PM   #21
jschiwal
Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655Reputation: 655
Code:
chkconfig --levels 35 mysql
or
Code:
chkconfig mysql 35
This will enable mysqld for run levels 3 and 5. Check the man page to see which will work. You may also need to use mysqld as the name instead. chkconfig is a wrapper around insserv so different distros may be slightly different. Newer distros may use systemd but still support starting services the old way.

Please stop trying to give "guest" users root access with sudo. The idea is inane and very dangerous.
 
  


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
Trying to write script that tests mysql login drigby Programming 3 04-09-2012 11:43 AM
starting mysql server using perl script vinaytp Linux - Newbie 1 05-20-2009 06:32 AM
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 08:44 PM
PHP login script using mysql issue ACDII Linux - Server 4 01-20-2007 05:58 AM
A good secure login script with PHP and mySQL genderbender Programming 3 05-02-2006 11:06 AM


All times are GMT -5. The time now is 03:11 PM.

Main Menu
Advertisement
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