LinuxQuestions.org
Visit Jeremy's Blog.
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 11-20-2004, 12:50 AM   #1
zobra
LQ Newbie
 
Registered: Nov 2004
Location: Sweden
Distribution: slackware 10
Posts: 6

Rep: Reputation: 0
starting mysqld


Hi again!
When Im logged in as root and trying to start /usr/bin/mysqld_safe
it says:

root@server:/usr/bin# mysqld_safe
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/lib/mysql/server.pid
041120 06:45:58 mysqld ended

When I tried it as another user I didnt have the permissions to start mysqld. I havent been able to create a root password either. But I havent been able to start mysqld so its been pretty hard to do that.
Thankful for whatever help you could give me. =)
 
Old 11-20-2004, 01:38 AM   #2
micxz
Senior Member
 
Registered: Oct 2002
Location: CA
Distribution: openSuSE, Cent OS, Slackware
Posts: 1,131

Rep: Reputation: 75
try the init script:
/etc/init.d/mysql start

Last edited by micxz; 11-20-2004 at 06:45 PM.
 
Old 11-20-2004, 01:47 AM   #3
tangle
Senior Member
 
Registered: Apr 2002
Location: Arbovale, WV
Distribution: Slackware
Posts: 1,761

Rep: Reputation: 78
Change the permission on the database to read/write for the group that mysql runs under. Also change the owner and group to the user/ group that mysql run under. That should fix it. Soory if this is a little confusing, it is really late.
 
Old 11-20-2004, 07:39 AM   #4
DertyolBA$HTARD
Member
 
Registered: Sep 2004
Location: USA
Distribution: Slackware 10
Posts: 86

Rep: Reputation: 15
If mysql is properly instled you should have a mysql user try su to that user and starting it as them, I use this command:

mysqld -Sg &
 
Old 11-20-2004, 06:16 PM   #5
zobra
LQ Newbie
 
Registered: Nov 2004
Location: Sweden
Distribution: slackware 10
Posts: 6

Original Poster
Rep: Reputation: 0
I looked in the /var/lib/mysql/server.err seemes to be an error.log or something. dunno. however. it says: Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist. Should I just create one?
 
Old 11-20-2004, 06:47 PM   #6
micxz
Senior Member
 
Registered: Oct 2002
Location: CA
Distribution: openSuSE, Cent OS, Slackware
Posts: 1,131

Rep: Reputation: 75
Did you just install it? Maybe you need to run mysql_install_db first and make sure "/etc/my.cnf" reads correctly.

Last edited by micxz; 11-20-2004 at 06:48 PM.
 
Old 12-07-2004, 12:27 AM   #7
nelsonrherron
LQ Newbie
 
Registered: Dec 2004
Posts: 2

Rep: Reputation: 0
You may have already solved this as it is getting a bit stale. But in case you are still after it the following reference may help. I had the problem and this solved it.

From Sams Teach Yourself MySQL in 21 Days, pg 27. It's possible you have corrupted databases. Delete /usr/local/mysql/var/mysql and run mysql_install_db again. I had this problem and running this procedure cleared it up as clean as a whistle.

The following log message from this file: /usr/local/mysql/var/FirstbaseLinux1.err was the second half of the error message about about the PID file closing the daemon.

041206 20:45:19 mysqld started
041206 20:45:19 InnoDB: Started
041206 20:45:19 Fatal error: Can't open privilege tables: Can't find file: './mysql/host.frm' (errno: 13)
041206 20:45:19 Aborting

041206 20:45:19 InnoDB: Starting shutdown...
041206 20:45:21 InnoDB: Shutdown completed
041206 20:45:21 /usr/local/mysql/libexec/mysqld: Shutdown Complete

041206 20:45:21 mysqld ended
 
  


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
Trouble starting mysqld koodoo Linux - Newbie 4 08-16-2005 11:09 AM
starting mysqld + OpenBSD Gsee *BSD 0 02-01-2005 06:36 AM
HELP! mysqld starting problem pravi Linux - Software 1 10-27-2004 12:20 PM
Problems with Mysqld Inexactitude Linux - Networking 1 02-21-2004 11:53 PM
Mysqld cinnix Linux - General 4 07-08-2001 02:42 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 12:50 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
Open Source Consulting | Domain Registration