LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 10-22-2009, 09:37 AM   #1
DotHQ
Member
 
Registered: Mar 2006
Location: Ohio, USA
Distribution: Red Hat, Fedora, Knoppix,
Posts: 548

Rep: Reputation: 33
mysql startup on new install


I'm working on a new cent-os install.

I know it's installed:
Code:
[root@ws2 lib]# which mysql
/usr/bin/mysql
Checked for updates:
Code:
[root@ws2 etc]# yum install mysql
Loaded plugins: fastestmirror
Loading mirror speeds from cached hostfile
 * extras: mirror.anl.gov
 * updates: mirror.anl.gov
 * base: mirrors.adams.net
 * addons: centos.corenetworks.net
Setting up Install Process
Parsing package install arguments
Package mysql-5.0.77-3.el5.i386 already installed and latest version
Nothing to do
--------------
Here is the error I get when I try to start mysql:

Code:
[root@ws2 lib]# mysql
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
I've searched and read that restarting mysql can solve this issue, but in checking I have no mysql daemon.

Code:
[root@ws2 lib]# service mysqld start
mysqld: unrecognized service
cat'ing my my.cnf file shows:

Code:
[root@ws2 lib]# cat /etc/my.cnf
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
But I have no /var/lib/mysql dir. I tried creating that dir and that did not help.
Any clue what I might try to make mysql run?

I've searched my system for the mysql.sock file but none exsits (used find and locate ...neither found anything).

Last edited by DotHQ; 10-22-2009 at 09:40 AM.
 
Old 10-22-2009, 09:53 AM   #2
acid_kewpie
Moderator
 
Registered: Jun 2001
Location: UK
Distribution: Gentoo, RHEL, Fedora, Centos
Posts: 43,417

Rep: Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985Reputation: 1985
the server is in the mysql-server package.
 
Old 10-22-2009, 09:59 AM   #3
cola
Senior Member
 
Registered: Sep 2007
Posts: 1,045

Rep: Reputation: 65
@DotHQ
Hello,does this work?
Code:
yum install mysql-server
 
Old 10-22-2009, 12:08 PM   #4
thegeek
Member
 
Registered: Oct 2009
Location: Amsterdam
Distribution: CentOS,Fedora,Puppy
Posts: 62

Rep: Reputation: 20
To make sure it is installed for startup use chkconfig !

example:

chkconfig mysqld on

chkconfig --list | grep mysql (to test it)
 
  


Reply


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
How-To run Apache, php, MySQL on startup and install phpMyAdmin - Slackware 12.2 Penthux Slackware 22 10-07-2012 10:44 PM
yum install php-mysql fails with mysql 5.1 - "Error: mysql conflicts with MySQL" rebelde Linux - Software 2 03-13-2009 10:32 AM
MySQL 5.0.67: Unable to install & run. Error /var/lib/mysql/mysql.sock' (2) peteyperson Linux - Server 2 03-04-2009 01:16 PM
mysql startup eyewittness Linux - Software 1 07-23-2005 09:04 AM
Mysql install and startup buttersoft Slackware - Installation 5 03-15-2005 04:39 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 07:38 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
Open Source Consulting | Domain Registration