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

news@celticbear.com

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

Jul 23 '05 #1

Dave Uhring

On Sat, 23 Apr 2005 14:16:47 -0700, new wrote:
[color=blue]
> 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[/color]

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

Jul 23 '05 #2

news@celticbear.com

Dave Uhring wrote:[color=blue]
> On Sat, 23 Apr 2005 14:16:47 -0700, new wrote:
>[color=green]
> > 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[/color]
>
> You failed to execute /usr/bin/mysql_install_db first.[/color]

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

Jul 23 '05 #3

Dave Uhring

On Sat, 23 Apr 2005 15:14:01 -0700, new wrote:
[color=blue]
> Dave Uhring wrote:[/color]
[color=blue][color=green]
>> You failed to execute /usr/bin/mysql_install_db first.[/color][/color]
[color=blue]
> 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.[/color]

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

Jul 23 '05 #4

news@celticbear.com

Dave Uhring wrote:[color=blue]
> On Sat, 23 Apr 2005 15:14:01 -0700, new wrote:
>[color=green]
> > Dave Uhring wrote:[/color]
>[color=green][color=darkred]
> >> You failed to execute /usr/bin/mysql_install_db first.[/color][/color]
>[color=green]
> > 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.[/color]
>
> [rc.d]# cd /var/lib
> [lib]# chown -R mysql:mysql mysql[/color]

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

Jul 23 '05 #5

Dave Uhring

On Sat, 23 Apr 2005 15:50:40 -0700, new wrote:
[color=blue]
> 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.[/color]

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

Jul 23 '05 #6