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.

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?

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

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

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

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".

["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

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.

> This is not windows, doofus.

Only a doofus would limit themselves only to Linux.

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*