LinuxQuestions.org
Latest LQ Deal: Linux Power User Bundle
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 05-01-2003, 07:43 PM   #1
bige
Member
 
Registered: Mar 2003
Location: Kansas
Distribution: debian
Posts: 44

Rep: Reputation: 15
Exclamation MySQL server not starting


i was wondering.... I just got done installing mysql server from source and it won't start it just gives me this:

Quote:
root@myPCsux:/usr/local/mysql/bin# Starting mysqld daemon with databases from /usr/local/mysql/var
030501 19:19:27 mysqld ended
never had this problem. I am using slackware 9.0, where is the config file by the way, Its not in /etc

any help is appreciated.
 
Old 05-01-2003, 08:24 PM   #2
Hangdog42
LQ Veteran
 
Registered: Feb 2003
Location: Maryland
Distribution: Slackware
Posts: 7,803
Blog Entries: 1

Rep: Reputation: 416Reputation: 416Reputation: 416Reputation: 416Reputation: 416
A few questions:

How are you starting the server? I use mysqld_safe & and it works without a problem.

Also, did you set up root as a user? If not, try starting with mysqld_safe --user=mysql &

Finally give this a read.
 
Old 05-02-2003, 02:25 AM   #3
markus1982
Senior Member
 
Registered: Aug 2002
Location: Stuttgart (Germany)
Distribution: Debian/GNU Linux
Posts: 1,467

Rep: Reputation: 46
The .err file (like markus.err if your hostname is markus) will contain valueable information that will help you to fix your problem!
 
Old 05-02-2003, 07:13 AM   #4
bige
Member
 
Registered: Mar 2003
Location: Kansas
Distribution: debian
Posts: 44

Original Poster
Rep: Reputation: 15
Post can't find ./mysql/host.frm

hey thanks for the help... Ya i am trying to start it w/ "mysqld_safe &" and also "mysqld_safe -user-mysql &" but it doesn't go... I think the answer lies in what markus was saying. When I look into the .err file it reads:
Quote:
030501 18:23:44 mysqld started
030501 18:23:44 /usr/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13)
030501 18:23:44 mysqld ended
what is host.frm anyways...
 
Old 05-02-2003, 07:25 AM   #5
bige
Member
 
Registered: Mar 2003
Location: Kansas
Distribution: debian
Posts: 44

Original Poster
Rep: Reputation: 15
Thumbs up I GOT IT

hey guys I got it. I did a little chowning and chgrping and it worked.

to be exact: chown root /usr/local/mysql
chown mysql /usr/local/mysql/var
chgrp mysql /usr/local/mysql

started it up and set my password and stuff is now running great. Thanks for your guys' help i would have never found out w/o ya.. Thanks marcos for the tip on the error message. I will have to remember that one. THANKS AGAIN.
 
Old 07-02-2003, 06:19 PM   #6
RussellEast
LQ Newbie
 
Registered: Jun 2003
Posts: 4

Rep: Reputation: 0
this thread was really helpful - thanx!
 
  


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
Problem on starting MySql Server Obscure Slackware 4 09-05-2009 07:24 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
mysql starting server landonmkelsey Linux - General 0 12-20-2003 09:20 AM
Starting Mysql server at booting time learner Linux - Software 2 09-22-2003 07:47 AM
MySQL Problem starting server oulevon Linux - Software 1 12-07-2002 01:47 PM


All times are GMT -5. The time now is 07:53 AM.

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