Help answer threads with 0 replies.
Go Back > Forums > Linux Forums > Linux - Software
User Name
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.


  Search this Thread
Old 11-16-2003, 05:02 PM   #1
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 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?

Old 11-16-2003, 05:42 PM   #2
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
LQ Newbie
Registered: Oct 2003
Location: Dallas, GA
Distribution: Slackware, Debian
Posts: 25

Rep: Reputation: 15
Try this:

as root type:

su mysql

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.

Old 11-17-2003, 01:14 AM   #4
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.

--- 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
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!


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 > Forums > Linux Forums > Linux - Software

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

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration