LinuxQuestions.org
Register a domain and help support LQ
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-16-2003, 05:02 PM   #1
belorion
Member
 
Registered: Aug 2003
Distribution: Slackware 10.0
Posts: 124

Rep: Reputation: 16
MySQL & Slack9.1


I am having problems trying to get MySQL running on Slackware 9.1.

I installed it during my normal installation process, and the boot process tries to start the server, but fails.

The same thing happens when I try to start it manually.

I execute mysqld_safe... I hear the computer start to work, and then I get a message saying "mysql" ended.

I've discovered that I have no mysql.sock file. The default location is /var/run/mysql/. The interesting thing is that if I "touch mysql.sock" in this location, it ends up being deleted after I try running the mysqld_safe. I've double checked the permissions on the directories to make sure that mysql can write to /var/run/mysql, and it seems okay.

I'm also noticing there is no mysql.host file anywhere.

The error I get looks like the following:

$> 031116 {time stamp} mysqld ended

THe 031116 code is the same every time. Any suggestions?

THanks.
 
Old 11-16-2003, 05:42 PM   #2
belorion
Member
 
Registered: Aug 2003
Distribution: Slackware 10.0
Posts: 124

Original Poster
Rep: Reputation: 16
I discovered another detail. I found an error log somewhere, which indicated that it was having problems finding the "hosts.frm"

Now, I did find this file, it was located in /var/lib/mysql/mysql/hosts.frm.

It was looking for it through the "./mysql/host.frm" path.

Still can't figure it all out those. Any suggestions?
 
Old 11-16-2003, 06:21 PM   #3
mlmurray
LQ Newbie
 
Registered: Oct 2003
Location: Dallas, GA
Distribution: Slackware, Debian
Posts: 25

Rep: Reputation: 15
Try this:

as root type:

su mysql
mysql_install

I just had the same problem. I was directed to do this somewhere, but I can't remember where. This apears to set up the default databases and users which the daemon needs to run.

Mark
 
Old 11-17-2003, 01:14 AM   #4
Cerbere
Member
 
Registered: Dec 2002
Location: California
Distribution: Slackware & LFS
Posts: 799

Rep: Reputation: 33
Ooops! Close, but no cigar, mlmurray. The command is mysql_install_db.

Enjoy!
--- Cerbere

[edit] And one more thing: after you run that command, type 'exit' to become root again. [/edit]

Last edited by Cerbere; 11-17-2003 at 01:16 AM.
 
Old 11-17-2003, 12:31 PM   #5
belorion
Member
 
Registered: Aug 2003
Distribution: Slackware 10.0
Posts: 124

Original Poster
Rep: Reputation: 16
Thanks, that did the trick.

Well, I had to fix permissions on a directory and its contents first, but then the above worked fine. Thanks a lot!
 
  


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
URGENT Cant login after upgrade (Slack9.1 & DL2.6) quo_vadis Slackware 1 04-18-2004 02:21 PM
Slack9.1 & VIA vt8233, sound recording fails Aldaron Linux - General 2 02-26-2004 09:21 AM
NVIDIA drivers & kernel 2.6.1 [slack9.1] darklogik_org Slackware 4 01-25-2004 01:17 PM
Slack9 & getting mozilla1.4 to fullscreen mode csDraco_ Slackware 0 07-21-2003 10:04 AM
mysql on slack9 vexed Slackware 7 04-09-2003 02:06 PM


All times are GMT -5. The time now is 06:19 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