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

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

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

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

Am I correct in assuming that the first version of MySQL you tired to get
running was the Slackware Package that comes with Slackware 12 CD or DVD?

When I try this from a new SW 12 install in a Virtual Machine the
following happens
# ./rc.mysqld start
# nohup redirecting stderr to stdout
Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server fro pid file /var/run/mysql/mysql.pid
080329 07:41:17 mysql ended

Does a similar thing happen to your system?
then run the following command
su mysql -c 'mysql_install_db'

This will install the base mysql database with the correct permissions.

Richard James
--
sig fail on line -1

On Fri, 28 Mar 2008, Dave Uhring wrote:

> Did you install the initial databases?
>
> /usr/bin/mysql_install_db

and I bet they have not made sure /var/lib/mysql is writable by
the user/group mysql



--
Cheers
Res

mysql> update auth set Framed-IP-Address='127.0.0.127' where user= 'troll';

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

> Am I correct in assuming that the first version of MySQL you tired to get
> running was the Slackware Package that comes with Slackware 12 CD or DVD?

It's the Slackware 12 DVD. I downloaded it just days after version 12
was announced.

> When I try this from a new SW 12 install in a Virtual Machine the
> following happens
> # ./rc.mysqld start
> # nohup redirecting stderr to stdout
> Starting mysqld daemon with databases from /var/lib/mysql
> STOPPING server fro pid file /var/run/mysql/mysql.pid
> 080329 07:41:17 mysql ended

Yes, this happens but the error log shows that a host.frm file is
missing.

permissions error, seen it before

On Fri, 28 Mar 2008, 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.
>

--
Cheers
Res

mysql> update auth set Framed-IP-Address='127.0.0.127' where user= 'troll';

On Fri, 28 Mar 2008 08:45:49 -0500, Peter H. Coffin wrote:

....snip...

> So it's likely someone building a package missed the file
> trying to run around the normal mysql_install_db script.

Nobody missed anything in the packaging; Slackware has always required
that mysql_install_db be run prior to using mysql.

The reason is quite simply understood. Slackware ships with packages made
from unaltered sources and building mysql source does not result in the
generation of the initial database set.