mysql not running

[linuxlearner]

I got
No mysqld pid file found. Looked for /var/lib/mysql/linuxserver.com.pid

when i use service mysqld restart or /usr/share/mysql/mysql.server restart or use Service monitor from DA

I tried to reinstall mysql 4.1, it ran through succesfully and i rebooted it but can't fix the problem.

my.cnf:

[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

is it correct as i can't find /var/run/mysqld/mysqld.pid

Please go easy on me, it's my 2nd day with Linux

 

[nobaloney]

A good place to look for error messages is /var/log/messages.

Jeff

 

[linuxlearner]

there's no error in those log files. i've search everywhere but no answer now.

Could you tell me how to uninstall mysql ? I don't even know what name to use for rpm -e

 

[linuxlearner]

hmm, i searched everywhere and no correct solutions. So i tried to delete mysql.server, mysql service is running back.

What's mysql.server? and how come mysql service is running from my DA but service mysqld status >> give nothing

Thanks.

 

[nobaloney]

/etc/rc.d/init.d/mysql.server is a control file for MySQL.

So is /etc/rc.d/init.d/mysqld.

You should only have one of them, depending on how MySQL was installed on your server.

But even more important is how they're called.

On RH based Linux servers and many others you'll find a directory at /etc/rc.d/rc3.d and in that directory you'll find ponters to one or both:

Try:

ls -al /etc/rc.d/rc3.d/*my*

to see what I mean.

The one that starts with an S, if any, will start mysqld. The one that starts with K, if any, will make sure it doesn't start.

Depdending on what you have, and how you installed MySQL, then you may or may not have done a bad thing.

Jeff