LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Server
User Name
Password
Linux - Server This forum is for the discussion of Linux Software used in a server related context.

Notices


Reply
  Search this Thread
Old 04-08-2007, 01:37 PM   #1
dbyy
LQ Newbie
 
Registered: Dec 2005
Posts: 7

Rep: Reputation: 0
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
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
 
Old 04-08-2007, 03:48 PM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981Reputation: 1981
so you've not actaully even started mysql? "service mysql start"
 
Old 04-11-2007, 09:06 PM   #3
dbyy
LQ Newbie
 
Registered: Dec 2005
Posts: 7

Original Poster
Rep: Reputation: 0
...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
 
Old 04-11-2007, 10:25 PM   #4
tehfatal
Member
 
Registered: Mar 2007
Location: NJ
Distribution: Slackware 11, Fedora Core 6, Opensuse 10.2, CentOS 4.4
Posts: 31

Rep: Reputation: 15
It appears you didnt get all the mysql components with the way you used yum.

Code:
rpm -qa | grep mysql
libdbi-dbd-mysql-0.6.5-10.RHEL4.1
mysqlclient10-devel-3.23.58-9.2.c4
mysql-5.0.27-1.el4.centos
php-mysql-5.1.6-3.el4s1.5
mysqlclient10-3.23.58-9.2.c4
mysql-server-5.0.27-1.el4.centos
mysql-bench-5.0.27-1.el4.centos
mysql-devel-5.0.27-1.el4.centos
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.
 
Old 04-11-2007, 10:33 PM   #5
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678
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.

Last edited by jschiwal; 04-14-2007 at 02:24 AM.
 
Old 04-11-2007, 10:55 PM   #6
Wim Sturkenboom
Senior Member
 
Registered: Jan 2005
Location: Roodepoort, South Africa
Distribution: Slackware 10.1/10.2/12, Ubuntu 12.04, Crunchbang Statler
Posts: 3,786

Rep: Reputation: 282Reputation: 282Reputation: 282
It might have to be service mysqld start. Not sure however.
 
Old 04-11-2007, 10:56 PM   #7
tehfatal
Member
 
Registered: Mar 2007
Location: NJ
Distribution: Slackware 11, Fedora Core 6, Opensuse 10.2, CentOS 4.4
Posts: 31

Rep: Reputation: 15
Quote:
Originally Posted by jschiwal
(Why did seeing the 'php' package above remind me of this?)
I bet you've had alot of fun trying to find help with php5 and mysql in the docs
 
Old 04-12-2007, 01:24 AM   #8
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678
I just answered another post where a server was hacked and PHP was mentioned.
 
Old 04-13-2007, 07:11 PM   #9
dbyy
LQ Newbie
 
Registered: Dec 2005
Posts: 7

Original Poster
Rep: Reputation: 0
Hi

Quote:
Look in /usr/share/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?)
there is no
Quote:
/usr/share/packages/mysql
.
However, there is </usr/share/mysql>, I guess that's the directory you mean.

Cheers
Fred
 
Old 04-13-2007, 07:13 PM   #10
dbyy
LQ Newbie
 
Registered: Dec 2005
Posts: 7

Original Poster
Rep: Reputation: 0
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
 
Old 04-14-2007, 02:25 AM   #11
jschiwal
LQ Guru
 
Registered: Aug 2001
Location: Fargo, ND
Distribution: SuSE AMD64
Posts: 15,733

Rep: Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678Reputation: 678
Quote:
Originally Posted by dbyy
Hi



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

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


Reply

Tags
centos4, mysql


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
when i try to start samba pdc's smb service nmbd failed to start . sandeepchau123 Linux - Newbie 2 10-20-2007 01:59 PM
Xvnc will not start (CentOS vps) WojtekO Linux - Software 1 11-09-2006 05:51 PM
msyql query from shell script hamish Linux - Software 5 06-02-2006 09:06 AM
CentOS 4.2, Making Apache, and VsFTP Start at bootup adnonimape Linux - Software 1 03-22-2006 05:08 AM
start LDAP on CENTOS! mumux Linux - Software 5 08-10-2005 06:00 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Server

All times are GMT -5. The time now is 12:41 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration