Unix Technical Forum

MySQL server exits

This is a discussion on MySQL server exits within the MySQL forums, part of the Database Server Software category; --> Hello, Under a newly installed copy of Slackware 12, I did a "chmod +x rc.mysqld" to ensure that mysqld ...


Go Back   Unix Technical Forum > Database Server Software > MySQL

Register FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 03-28-2008, 04:41 AM
plenty900@yahoo.com
 
Posts: n/a
Default MySQL server exits

Hello,

Under a newly installed copy of Slackware 12, I did a
"chmod +x rc.mysqld" to ensure that mysqld is started
during boot up. I then rebooted and tried to run
mysqladmin to set the database's root password.
I also tried the database initialization script.
Unfortunately it seems that mysqld_safe refuses to run
under Slackware. I even discovered that the rc.mysql script
fails during startup.

Anybody know how to fix this?

I then tried uninstalling and then compiling MySQL from
source and installing that, but the server continues
to exit during boot-up and when I try to run it
from the command line, and without any useful error message.

Thanks.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #2 (permalink)  
Old 03-28-2008, 04:41 AM
Jerry Stuckle
 
Posts: n/a
Default Re: MySQL server exits

plenty900@yahoo.com wrote:
> Hello,
>
> Under a newly installed copy of Slackware 12, I did a
> "chmod +x rc.mysqld" to ensure that mysqld is started
> during boot up. I then rebooted and tried to run
> mysqladmin to set the database's root password.
> I also tried the database initialization script.
> Unfortunately it seems that mysqld_safe refuses to run
> under Slackware. I even discovered that the rc.mysql script
> fails during startup.
>
> Anybody know how to fix this?
>
> I then tried uninstalling and then compiling MySQL from
> source and installing that, but the server continues
> to exit during boot-up and when I try to run it
> from the command line, and without any useful error message.
>
> Thanks.
>


Anything in the MySQL or system log files?

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #3 (permalink)  
Old 03-28-2008, 04:41 AM
Ana C. Dent
 
Posts: n/a
Default Re: MySQL server exits

plenty900@yahoo.com wrote in news:c59ebd27-0231-4e78-b4c2-d5db062796e8
@u69g2000hse.googlegroups.com:

> Hello,
>
> Under a newly installed copy of Slackware 12, I did a
> "chmod +x rc.mysqld" to ensure that mysqld is started
> during boot up. I then rebooted and tried to run
> mysqladmin to set the database's root password.
> I also tried the database initialization script.
> Unfortunately it seems that mysqld_safe refuses to run
> under Slackware. I even discovered that the rc.mysql script
> fails during startup.
>
> Anybody know how to fix this?
>
> I then tried uninstalling and then compiling MySQL from
> source and installing that, but the server continues
> to exit during boot-up and when I try to run it
> from the command line, and without any useful error message.
>
> Thanks.
>


Is there any interesting information in the error log file?
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #4 (permalink)  
Old 03-28-2008, 04:41 AM
Dave Uhring
 
Posts: n/a
Default Re: MySQL server exits

On Thu, 27 Mar 2008 18:32:18 -0700, plenty900 wrote:

> Under a newly installed copy of Slackware 12, I did a "chmod +x
> rc.mysqld" to ensure that mysqld is started during boot up. I then
> rebooted and tried to run mysqladmin to set the database's root
> password. I also tried the database initialization script. Unfortunately
> it seems that mysqld_safe refuses to run under Slackware. I even
> discovered that the rc.mysql script fails during startup.


Did you install the initial databases?

/usr/bin/mysql_install_db
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #5 (permalink)  
Old 04-03-2008, 02:49 PM
plenty900@yahoo.com
 
Posts: n/a
Default Re: MySQL server exits


> Is there any interesting information in the error log file?


It turns out, my [hostname].err file shows that mysqld can't find a
file called host.frm.

I don't recall such a file when I recently installed MySQL under
Windows.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #6 (permalink)  
Old 04-03-2008, 02:49 PM
Dan C
 
Posts: n/a
Default Re: MySQL server exits

On Fri, 28 Mar 2008 05:34:43 -0700, plenty900 wrote:

> I don't recall such a file when I recently installed MySQL under
> Windows.


This isn't Windoze, n00b.

> X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 6.0
> User-Agent: G2/1.0


Ummm. Yeah.


--
"Ubuntu" -- an African word, meaning "Slackware is too hard for me".

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #7 (permalink)  
Old 04-03-2008, 02:49 PM
Dave Uhring
 
Posts: n/a
Default Re: MySQL server exits

On Fri, 28 Mar 2008 05:34:43 -0700, plenty900 wrote:

> It turns out, my [hostname].err file shows that mysqld can't find a
> file called host.frm.
>
> I don't recall such a file when I recently installed MySQL under
> Windows.


This is not windows, doofus. The initial databases are not installed by
default. YOU must do that if you want to run mysql and you do that by
executing mysql_install_db. Then you must

chown -R mysql:mysql /var/lib/mysql

Only then can you start mysqld and enter root's password.

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #8 (permalink)  
Old 04-03-2008, 02:49 PM
Peter H. Coffin
 
Posts: n/a
Default Re: MySQL server exits

["Followup-To:" header set to comp.databases.mysql.]
On Fri, 28 Mar 2008 05:34:43 -0700 (PDT), plenty900@yahoo.com wrote:
>
>> Is there any interesting information in the error log file?

>
> It turns out, my [hostname].err file shows that mysqld can't find a
> file called host.frm.
>
> I don't recall such a file when I recently installed MySQL under
> Windows.


It's part of the `host` table in the `mysql` database. Rerunning
mysql_install_db may fix the problem. Check your my.cnf file for
appropriate values for --datadir and --basedir.

--
96. My door mechanisms will be designed so that blasting the control panel on
the outside seals the door and blasting the control panel on the inside
opens the door, not vice versa.
--Peter Anspach's list of things to do as an Evil Overlord
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #9 (permalink)  
Old 04-03-2008, 02:49 PM
plenty900@yahoo.com
 
Posts: n/a
Default Re: MySQL server exits


> This is not windows, doofus.


Only a doofus would limit themselves only to Linux.
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
  #10 (permalink)  
Old 04-03-2008, 02:49 PM
mr.b
 
Posts: n/a
Default Re: MySQL server exits

On Fri, 28 Mar 2008 14:10:47 -0700, plenty900 wrote:

>> This is not windows, doofus.

>
> Only a doofus would limit themselves only to Linux.


good luck with the attitude buttwinkle

*plonk*
Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 05:22 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com