LinuxQuestions.org
Latest LQ Deal: Latest LQ Deals
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 08-27-2005, 09:40 AM   #1
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Rep: Reputation: 15
Angry Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon


Hi friends,
I just installed MySQL 3.23.58 on an FC2 machine, but I can not start it :

Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]

Please note that I found some threads recommending edit the mysqld scripts to $RANDOM and etc. But :
I did not find any thing similar to recommendations in my own mysqld file and when I tried to change the similar parts I did not obtain any success and got same error message.
Thank you,
 
Old 08-27-2005, 09:50 AM   #2
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Did you actually run or install a DB yet(install_mysql_db)? What do your logs tell you, with any more verbose error messages besides [FAILED]?
 
Old 08-27-2005, 10:23 AM   #3
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Original Poster
Rep: Reputation: 15
Dear friend,
I have already run mysql_install_db and unfortunately there is no special log in my log file just :
Aug 27 01:15:20 fed02 mysqld: Starting MySQL: failed
and :
service mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: FAILED

thank you again,
 
Old 08-27-2005, 10:26 AM   #4
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
You mean there is nothing in your /var/run/mysql or might be in /var/lib/mysql .err log files with any verbose errors to actually determine why mysql is failing to start?

Are you using the Fedora startup script or by any particular command?
 
Old 08-27-2005, 10:53 AM   #5
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Original Poster
Rep: Reputation: 15
Dear friend,
I used service command in addition to ./mysqld script to start it :
./mysqld start
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
but I got same error message.
In addition when I check the logs in /var/lib I do not find any thing.... unless some logs related to another version of MySQL (previous one).
Regards,
 
Old 08-27-2005, 10:59 AM   #6
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Original Poster
Rep: Reputation: 15
In addtiion this is the relevant part of mysqld script after recommended modifications:

if [ $ret -eq 0 ]; then
STARTTIMEOUT=10
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null` && break
echo "$RESPONSE" | grep -q "Access denied for user" && break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi
 
Old 08-27-2005, 11:14 AM   #7
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Original Poster
Rep: Reputation: 15
More info

In addition when i try to get the status of mysqld :

service mysqld status
mysqld dead but subsys locked

Thank you,
 
Old 08-27-2005, 11:23 AM   #8
trickykid
LQ Guru
 
Registered: Jan 2001
Posts: 24,149

Rep: Reputation: 269Reputation: 269Reputation: 269
Quote:
Originally posted by Fr33B5D
In addtiion this is the relevant part of mysqld script after recommended modifications:

if [ $ret -eq 0 ]; then
STARTTIMEOUT=10
while [ $STARTTIMEOUT -gt 0 ]; do
RESPONSE=`/usr/bin/mysqladmin -u $RANDOM ping 2> /dev/null` && break
echo "$RESPONSE" | grep -q "Access denied for user" && break
sleep 1
let STARTTIMEOUT=${STARTTIMEOUT}-1
done
if [ $STARTTIMEOUT -eq 0 ]; then
echo "Timeout error occurred trying to start MySQL Daemon."
action $"Starting $prog: " /bin/false
else
action $"Starting $prog: " /bin/true
fi
Did mysql start before these modifications? If so, remove them and attempt to restart.
 
Old 08-27-2005, 11:06 PM   #9
Fr33B5D
Member
 
Registered: Aug 2005
Location: France
Posts: 43

Original Poster
Rep: Reputation: 15
Dear friend it did not work fine before modifications in mysqld script and now after them does not work too.
I think that the last solution is matching a newer version of MySQL ,maybe 4.1, with Fedora2 and installing that..
What is your suggestion?
 
Old 10-28-2006, 06:23 AM   #10
abhi2778
LQ Newbie
 
Registered: Jul 2006
Posts: 13

Rep: Reputation: 0
Angry

Hello ,

I am in mess i have started 2 mysqld server process how to

kill one of server permanently .(3390) .

Because of this errror my sugar CRM cannot locate database .


Plz go through it .

service mysqld restart
Stopping MySQL: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost root]# service mysqld status
mysqld (pid 3390) is running...
[root@localhost root]# service mysqld restart
Stopping MySQL: [ OK ]
Timeout error occurred trying to start MySQL Daemon.
Starting MySQL: [FAILED]
[root@localhost root]# service mysqld status
mysqld (pid 3497) is running...
[root@localhost root]# ps -el |grep mysqld
4 S 0 3473 1 0 83 0 - 1235 wait4 pts/0 00:00:00 safe_mysqld
4 S 27 3497 3473 0 76 0 - 7688 - pts/0 00:00:00 mysqld


Plz help me out .
 
  


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
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. NoviceW Linux - Networking 17 09-17-2014 02:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 01:52 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 08:44 AM
Mysql daemon error Drogo Linux - Software 5 10-22-2004 02:17 PM
MySql error 2002, Cannot start mysql djchris Linux - Software 5 04-13-2004 06:12 PM

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

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