msyql service won't start on CentOS 4.4
 

hi everyone,

I hope this is the correct forum for my question.

I'm using CentOS 4.4 (RHEL) and trying to get mysql installed.
I applied 'yum mysql mysql-devel mysql-server'. After that it seems to me that mysql is installed, but not running on my box.
I checked the running processes in 'system-monitor' but mysql is not listed.
when trying to connect to mysql; (with GUI mysql-adminitrator) it shows <Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)>/

I'm reading now for two days online forums, mysql website and CentOS docu and I have to say I'm getting more and more confused what's to do and what not :mad:
I installed mysql before on Win-Xp and on Debian but I havent' had such a hard time as now.

btw. in directory /etc/init.d there is a file mysql.

I hope someone knows some help.
I really would like to get this installation completed to replace Debian.

any help much appreciated
TIA

Fred

so you've not actaully even started mysql? "service mysql start"

...mysql service not running
 

Hi Chris,

the service is not been started during boot of the system (system monitor doesn't list mysql).
When I try to start the mysql service (service mysql start) from terminal command line, it shows the message: "mysql: unrecognized service".

Thats were I'm stumbled, what I can see, the service hasn't been started and I not even can start the service manually.

I'm sure I'm missing here one or more steps, but which one's?

TIA

Cheers
Fred

It appears you didnt get all the mysql components with the way you used yum.

My output of 'rpm -qa | grep mysql'. I used 'yum install --enable=centosplus mysql*' to install mysql, I believe you'll get mysql 4.x.x if you dont use the plus repo.

Using the wild card you'll get everthing related to mysql. Except the php-mysql-5.1.6-3.el4s1.5 , but this is just additional yum command.

Look in /usr/share/doc/packages/mysql/. There should be a comprehensive manual, which includes installing and things to do after installing mysql, as well as a trouble shooting chapter. The section on securing mysql is very important. (Why did seeing the 'php' package above remind me of this?)

CentOS should have a gui config program to enable mysql under certain runlevels. Or you could use the chkconfig program to do the same. This assumes that the service control script is present in /etc/init.d/.

Some of the packages like php-mysql and mysql-bench may not be necessary. For example, if you aren't running a LAMP server or don't have php scripts that access the mysql database, then php-mysql isn't needed. It adds mysql support for php and is not a part of mysql proper. The mysql-bench, I presume, is for benchmarking. The mysql-client package is important because it contains the mysql, mysqladmin, mysqldump, etal, client programs.

It might have to be service mysqld start. Not sure however.

I bet you've had alot of fun trying to find help with php5 and mysql in the docs :p

I just answered another post where a server was hacked and PHP was mentioned.

Hi

there is no .
However, there is </usr/share/mysql>, I guess that's the directory you mean.

Cheers
Fred

Hi everyone,

Now I had some progress (finally), when I run <service mysqld start> then mysql gets started.
I think now I can continue to complete my setup.

Thanks guys.

Fred

Sorry, I meant </usr/share/doc/packages/mysql/>. I corrected my previous post.