mysql setup problem

king_of_inismac

Ok,
I'm trying to setup a webserver with a mysql database.
However, when I try to start mysql on my unix machine with the command:

safe_mysqld &

The following happens:

Starting mysqld daemon with databases from /var/lib/mysql
031012 10:08:14 mysqld ended


What am I doing wrong?

Please help

Thanks

colonelx

Hi,

first off you may need to include more details,
OS , version of mysql etc.

Anyways here are some ideas

/var/lib/mysql (I assume this directory exists) if so who owns it / has access to it. Ensure that the user you are starting mysql with has write access to this directory.

secondly
have a look in the system logs
eg /var/log/messages and see if there are any errors being reported there.

king_of_inismac

Im running redhat 8.0 and I'm logged in as root, so can't see permissions as a problem...


checked out the messages in the log directory, but can't seem to find any error messages referring to mysql....

colonelx

Did you install mysql as an rpm or did it come as part of
the redhat install ?

king_of_inismac

mysql came with the redhat cds, however it was not installed initially with the redhat intall. I had to install it by going to the systems settings and installing it from there...

colonelx

so i guess it was an RPM that u installed ?

see if the file
/etc/rc.d/init.d/mysql
exists , or something very like it. This is a script which gets called upon startup .
if it does exist
try
./mysql start and see what happens.

Failing that , I dont really know what the problem could be.
Detail out how you installed mysql on the machine.

decob

Originally posted by king_of_inismac
Ok,
I'm trying to setup a webserver with a mysql database.
However, when I try to start mysql on my unix machine with the command:

safe_mysqld &

The following happens:
Starting mysqld daemon with databases from /var/lib/mysql
031012 10:08:14 mysqld ended
What am I doing wrong?

Please help

Thanks

Afair you need to start it as the mysql user,
so something like
safe_mysqld --user=mysql &

or....
su - mysql
then safe_mysqld &

king_of_inismac

Thanks for all the help guys, but it's still giving me the same error....?

lynchie

If you installed the mysql rpms in rh8 then just start mysql with service mysqld start on the command line. It shouldnt give any errors then, unless the rpm install went wrong

flamegrill

Hi,

As people have been getting at, if the directory mysql is looking for isn't there, or has the wrong ownership it won't start.

ls -la /var/lib/mysql

The dir should be owned by mysql and all files therein aswell.

If its something else, install apt (apt.freshrpms.net) remove the mysql you have install and install the apt version. See how you get on from there.

Paul

p.s. there is a problem with the rpm version on redhat that can cause rpm/apt to lock up. Best update rpm aswell.