LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 08-18-2008, 07:20 AM   #1
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466
Blog Entries: 6

Rep: Reputation: 51
MySQL not starting Up?


I have been facing the problem during the mysql starting up.Anyone who can help me get rid of that:

Code:
root@tuxbuddy tmp]# mysql -u root -p

Enter password:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

[root@tuxbuddy  tmp]# cd

[root@tuxbuddy  ~]# mysqladmin -u root password 'mysql123'

mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)'

Check that mysqld is running and that the socket: '/var/lib/mysql/mysql.sock' exists!

[root@tuxbuddy  ~]# service mysql stop

MySQL manager or server PID file could not be found!       [FAILED]

[root@tuxbuddy  ~]# rpm -qa | grep mysql
 
Old 08-18-2008, 07:25 AM   #2
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Did you try

service mysql start

?

edit - what distro are you running - it may be mysqld

Note there is a server and a client

Last edited by billymayday; 08-18-2008 at 07:27 AM.
 
Old 08-18-2008, 08:13 AM   #3
farslayer
LQ Guru
 
Registered: Oct 2005
Location: Northeast Ohio
Distribution: linuxdebian
Posts: 7,249
Blog Entries: 5

Rep: Reputation: 191Reputation: 191
So did this command produce no output ?

Code:
[root@tuxbuddy  ~]# rpm -qa | grep mysql
 
Old 08-18-2008, 09:30 AM   #4
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466

Original Poster
Blog Entries: 6

Rep: Reputation: 51
Ya the Server and Clients are there.
All It has mysql but not mysqld as daemon?

Am I missing any package?
 
Old 08-18-2008, 10:09 AM   #5
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Do a ps and grep mysqld?

ps fax | grep mysqld

And see if any process is running. If not, try to start it up and give us exact error from the logs, not what's outputted on the console or terminal.
 
Old 08-18-2008, 11:58 PM   #6
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466

Original Poster
Blog Entries: 6

Rep: Reputation: 51
[root@tuxbuddy~]# rpm -e --nodeps MySQL-client-standard-5.0.18-0.rhel4
[root@ ~]# rpm -e --nodeps MySQL-python-1.2.1_p2-1.el4.1
[root@ ~]# rpm -e --nodeps MySQL-server-standard-5.0.18-0.rhel4
[[root@ ~]# service mysql restart
mysql: unrecognized service
[root@ ~]# rpm -e --nodeps mysql-8
error: package mysql-8 is not installed
[root@ ~]# rpm -e --nodeps mysql-*
error: package mysql-* is not installed
[root@ ~]# ls
[root@ ~]# cd /tmp
[root@ tmp]# rpm -ivh MySQL-server-standard-5.0.18-0.rhel4.x86_64.rpm
warning: MySQL-server-standard-5.0.18-0.rhel4.x86_64.rpm: V3 DSA signature: NOKEY, key ID 5072e1f5
Preparing... ########################################### [100%]
1:MySQL-server-standard ########################################### [100%]
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h BL08DL385.mailserver.com password 'new-password'
See the manual for more instructions.

NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run
the /usr/bin/mysql_fix_privilege_tables. Otherwise you will not be
able to use the new GRANT command!

Please report any problems with the /usr/bin/mysqlbug script!

The latest information about MySQL is available on the web at
http://www.mysql.com
Support MySQL by buying support/licenses at https://order.mysql.com
Starting MySQL...................................[FAILED]
[root@ tmp]#
 
Old 08-19-2008, 12:02 AM   #7
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466

Original Poster
Blog Entries: 6

Rep: Reputation: 51
It Says:

MySQL manager or server PID file could not be found!
 
Old 08-19-2008, 12:10 AM   #8
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Now you've installed the server, you need to start it. Try service mysqld start (note that mysql is the client, mysqld is the server)
 
Old 08-19-2008, 01:32 AM   #9
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466

Original Poster
Blog Entries: 6

Rep: Reputation: 51
[root@tmp]# service mysqld restart
mysqld: unrecognized service
[root@tmp]#


FYI
 
Old 08-19-2008, 01:32 AM   #10
your_shadow03
Senior Member
 
Registered: Jun 2008
Location: Germany
Distribution: Slackware
Posts: 1,466

Original Poster
Blog Entries: 6

Rep: Reputation: 51
Ok...I donno whats going on..
I want to install a new SQL Package ...How to go for that?

Pls Help
 
Old 08-19-2008, 01:53 AM   #11
r3sistance
Senior Member
 
Registered: Mar 2004
Location: UK
Distribution: CentOS 6/7
Posts: 1,375

Rep: Reputation: 217Reputation: 217Reputation: 217
Looks to me like the Mysql Deamon failed to install properly. The file for mysqld was not added to /etc/init.d/ what makes me think it failed somewhere but what you got is not saying where that is. you could check /etc/init.d/ for a mysqld related file but my guess is it isn't their.
 
Old 08-19-2008, 02:03 AM   #12
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
What does

find / -type f -name *mysqld*

show?

Are you running RHEL4? Where did you get the rpm you are installing?
 
Old 08-19-2008, 09:54 AM   #13
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Quote:
Originally Posted by billymayday View Post
What does

find / -type f -name *mysqld*
I prefer updating the db with updatedb and then using locate, much faster. You can also use the which command when looking for a specific command.
 
Old 08-19-2008, 05:46 PM   #14
billymayday
LQ Guru
 
Registered: Mar 2006
Location: Sydney, Australia
Distribution: Fedora, CentOS, OpenSuse, Slack, Gentoo, Debian, Arch, PCBSD
Posts: 6,678

Rep: Reputation: 122Reputation: 122
Quote:
Originally Posted by trickykid View Post
I prefer updating the db with updatedb and then using locate, much faster. You can also use the which command when looking for a specific command.
So do I for my use, but I prefer to give a cut and paste soln where possible.

Cheers


BM
 
  


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
Problem Starting MySQL on Fresh Fedora 8 Install w/ Yum'd MySQL blong4life Linux - Server 2 07-04-2008 07:44 PM
How to overcome the RPM "mysql-5.0.27-1.fc6" conflict with mysql database starting kamakshiganesh Linux - General 0 10-22-2007 07:07 AM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 06:23 AM
starting mysql apax Linux - Newbie 4 12-28-2003 07:50 AM
starting mysql studentforever Linux - Software 10 09-18-2003 04:34 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie

All times are GMT -5. The time now is 02:55 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