LinuxQuestions.org
Download your favorite Linux distribution at LQ ISO.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 07-27-2003, 12:40 AM   #1
jerry_redhat
LQ Newbie
 
Registered: Jul 2003
Location: Australia
Distribution: RedHat 8.0
Posts: 10

Rep: Reputation: 0
Getting mysql4 to run as a Service


I can start my MySQL server with

# cd /usr/local/mysql
# bin/safe_mysqld --user=myuser --pass=mypass

Starting mysqld daemon with databases from /usr/local/mysql/data

----
Then the server is started and it all works fine, the only thing is i can't just make a shell script and stick it in /etc/rc.d/rc.local because when it run those commands and it says its starting it just hangs there

so when i put it in rc.local it hangs while its booting up and i have to go into rescuse mode and fix it.

And when i try to launch /usr/local/mysql/bin/mysqld --user=root
i get
Fatal Error: Can't Open Privilege tables: Table 'mysql.host' doesn't exist

and i'm not sure what to put in that file

any help would be greatly appreciated
 
Old 07-27-2003, 05:17 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974Reputation: 1974
well do you not have a proper daemon script set up for mysql?

/etc/init.d/mysqld start

or such like. if that works add mysqld to your default runlevel. on redhat i think this should still be:

chkconfig --levels 3 5 mysqld on
 
  


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
Removing MySQL4.1 and Installing MySQL4.0.* critical Linux - Software 2 08-04-2005 11:26 PM
How do I run a PHP script as a service? robbiemorgan Linux - Newbie 3 04-13-2005 03:03 PM
run perl service on Linuxstartup shahidawan Programming 2 03-30-2005 12:57 PM
run app as service MiniBubba Mandriva 3 09-19-2004 08:51 AM
Run as Service... tisource Linux - General 2 08-18-2002 05:27 PM


All times are GMT -5. The time now is 08:57 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
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration