Can't seem to start MySQL daemon

[PaulTEG]

Hi,

I'm new to Linux, and am trying to get MySQL up and running

root>/etc/init.d/mysql start
Starting service MySQL

but when I look up the process table (ps -ux) there's no daemon running.

I've looked up a few posts, and tried various things to no avail, including looking for another service running on the same port 3306

Any ideas??
--Paul

It's important in life to always strike a happy medium, so if you see someone with a crystal ball, and a smile on their face ...

 

[QatQat]

What version of Linux and MySQL are you using?

Have you correctly finalized the installation?

Did you run the mysql_install_db, mysql_fix_privilege_table scripts?

If you have alerady done the above steps, have you tried

>/etc/init.d/mysqld_safe start


Bye


Qatqat

Life is what happens when you are making other plans.

 

[PaulTEG]

SuSE 8.2, and 3.23.55

It looks like a problem with privs, now it can't find ./mysql/host.frm

I haven't come across the mysql_fix_privilege_table, but I'm looking

Cheers
--Paul

 

[QatQat]

That is more of a problem of mysql_install_db.

If I am not wrong, this script creates all user / rights related tables. The host table should set rights to different databases from different hosts.

The script should be in
/usr/bin


Bye


Qatqat

Life is what happens when you are making other plans.