mySQL won't start..errors out after installing (Slackware)

ne...@celticbear.com

unread,

Apr 23, 2005, 5:16:47 PM4/23/05

to

I just installed Slackware 10.1 Still need to install some missing
needed libraries, but I think that's unrelated.

Every time it boots up, or I try "/etc/rc.d/rc.mysqld start" I get
this:

Starting mysqld daemon with databases from /var/lib/mysql
STOPPING server from pid file /var/run/mysql/mysql.pid
mysqld ended

In /var/lib/mysql I have:
ib_arch_log_00000000
ib_logfile0
ib_logfile1
ibdata1
localhost.err

In /var/lib/mysql/localhost.err I have the following:
---
mysqld started
InnoDB: started
Fatal error: can't open privilige tables: Table 'mysql.host' do$
aborting

InnoDB: Starting shutdown...
InnoDB: Shutdown completed

/usr/libexec/mysqld: shutdown complete

mysqld ended
---

Any suggestions what in the world I should do? What I should try or
look at for more info?

Thanks for any help!
Liam

Dave Uhring

unread,

Apr 23, 2005, 5:44:54 PM4/23/05

to

On Sat, 23 Apr 2005 14:16:47 -0700, new wrote:

> I just installed Slackware 10.1 Still need to install some missing
> needed libraries, but I think that's unrelated.
>
> Every time it boots up, or I try "/etc/rc.d/rc.mysqld start" I get
> this:
>
> Starting mysqld daemon with databases from /var/lib/mysql
> STOPPING server from pid file /var/run/mysql/mysql.pid
> mysqld ended

You failed to execute /usr/bin/mysql_install_db first.

ne...@celticbear.com

unread,

Apr 23, 2005, 6:14:01 PM4/23/05

to

Oh, didn't know I had to do that. All my other distros installs have
been RedHat/Fedora and they pretty much do everything for you.

So I did that, and I got a screen of info, but it's an 80x30 laptop
screen so it all scrolls past and I can't see all the results...but it
tells me to set a root password AFTER starting the service, tells me an
upgrade notice.
And when I look at /var/lib/mysql I now have mysql/ and test/ dirs with
files in them.
So, it looks like that worked.

However, if I try starting the service I get the same errors.
/etc/rc.d/rc.mysqld start
or
/usr/bin/mysqld_safe &

either way, same "...STOPPING from pid file..." error.

Thanks for the reply! That does get me one step closer!
Liam

Dave Uhring

unread,

Apr 23, 2005, 6:42:01 PM4/23/05

to

On Sat, 23 Apr 2005 15:14:01 -0700, new wrote:

> Dave Uhring wrote:

>> You failed to execute /usr/bin/mysql_install_db first.

> However, if I try starting the service I get the same errors.

> /etc/rc.d/rc.mysqld start
> or
> /usr/bin/mysqld_safe &
>
> either way, same "...STOPPING from pid file..." error.

[rc.d]# cd /var/lib
[lib]# chown -R mysql:mysql mysql

ne...@celticbear.com

unread,

Apr 23, 2005, 6:50:40 PM4/23/05

to

Well, that did. Fixed it right up.

Should I have know that I'd have to do that? Did I miss something
somewhere? I never would have thought to check ownership of the
contents of that DIR.

I appreciate the help!!
Liam

Dave Uhring

unread,

Apr 23, 2005, 7:01:01 PM4/23/05

to

On Sat, 23 Apr 2005 15:50:40 -0700, new wrote:

> Should I have know that I'd have to do that? Did I miss something
> somewhere? I never would have thought to check ownership of the
> contents of that DIR.

You might want to read the files in /usr/doc/mysql-4.0.23a