MySQL Not starting. Can't find solution

[rbrugman]

Hey everyone,
When I try to start mysql (safe_mysqld), I get this error in the error log:

020715 23:29:45 mysqld started
020715 23:29:46 /usr/local/libexec/mysqld: Can't create/write to file '/usr/lo$
020715 23:29:46 /usr/local/libexec/mysqld: Can't find file: './mysql/host.frm'$
020715 23:29:46 /usr/local/libexec/mysqld: Error on delete of '/usr/local/var/$
020715 23:29:46 mysqld ended

I did a chgrp mysql var on /usr/local/var and now it reads:

drwxr-x--- 4 root mysql 128 Jul 15 23:29 var

Does anyone know what's going on?

[paradox]

I would think you would want it rwxrwxr--

but I might be wrong :-\

[rbrugman]

OK, I've decided to complely start over. Does anyone know of a link about installing from the source. All I see is the binary readme's.

[trommaster]

it might be a stupid question, but are you logged in as root???

[rbrugman]

yes, I'm logged in as root, and safe_mysqld starts, but I cant get the non "safe" one working.

[JimH]

Is there any reason you are trying to install from source instead of using the MySQL packages included with your Linux distribution?

What Linux distro/version are you using?

Jim H

[rbrugman]

I'm using SuSE 8.0, and I am using the source because the version SuSE came with was version 3.23.3x or something. I actually found a readme on step-by-step what to do with the source. I'll tell you how it goes.

[JimH]

I'm using SuSE 8.0, and I am using the source because the version SuSE came with was version 3.23.3x or something.

So you need a feature offered in the lastest version that is not present in the version Suse ships?

I actually found a readme on step-by-step what to do with the source. I'll tell you how it goes.

I believe the MySQL docs give detailed instructions on howto compile and install from source.

Jim H