LinuxQuestions.org
Welcome to the most active Linux Forum on the web.
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 02-02-2004, 02:09 AM   #1
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Rep: Reputation: 32
mysql error on boot up


Hi i have reinstall Fedora core 1.

every thing seems to be fine, I restarted the system and mysql was green ok.

I added my root password for mysql and added a new user with pass to a certain database., i did a restart and now i get an fail on the mysql on start up.

I did a /etc/rc.d/init.d/ mysqld status and its running
any one tell me whats wrong ? and how to fix please ?


thanks TT
 
Old 02-02-2004, 02:12 AM   #2
snacky
Member
 
Registered: Feb 2004
Distribution: Debian
Posts: 286

Rep: Reputation: 30
Not without the error messages, we can't tell.
 
Old 02-02-2004, 02:41 AM   #3
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
its comes up with a time out error some thing to do with mysql demon, it went to quick for me to read it..

TT
 
Old 02-02-2004, 02:45 AM   #4
snacky
Member
 
Registered: Feb 2004
Distribution: Debian
Posts: 286

Rep: Reputation: 30
Should be in /var/log/debug.

In the extremely unlikely event that it isn't, next time redirect stderr to a file:

command 2> error.log
 
Old 02-02-2004, 02:46 AM   #5
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
Yep thats it

Time out error trying to start mysql demon, sorry for the spelling mistake.

TT
 
Old 02-02-2004, 02:52 AM   #6
snacky
Member
 
Registered: Feb 2004
Distribution: Debian
Posts: 286

Rep: Reputation: 30
Paste all of the exact error messages. I have no idea what's going on without them.

(possibly I'll have no idea what's going on WITH them either, but...)
 
Old 02-02-2004, 02:53 AM   #7
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
well i went hunting for the /var/log/debug and its not there.

all i can see is this under the file /var/log.mysql.log

040202 15:44:14 mysqld started
Cannot initialize InnoDB as 'innodb_data_file_path' is not set.
If you do not want to use transactional InnoDB tables, add a line
skip-innodb
to the [mysqld] section of init parameters in your my.cnf
or my.ini. If you want to use InnoDB tables, add to the [mysqld]
section, for example,
innodb_data_file_path = ibdata1:10M:autoextend
But to get good performance you should adjust for your hardware
the InnoDB startup options listed in section 2 at
http://www.innodb.com/ibman.html
/usr/libexec/mysqld: ready for connections

I am at a lost to this, its the only one that says Failed on the start up

TT
 
Old 02-02-2004, 03:00 AM   #8
snacky
Member
 
Registered: Feb 2004
Distribution: Debian
Posts: 286

Rep: Reputation: 30
OK, you can either download innodb (not really necessary) or you can edit the my.cnf file in the way it suggests. Also, it IS starting mysqld, isn't it? From the output you listed, it is. If it works when you run "mysql," then it's ok as it is...
 
Old 02-02-2004, 03:04 AM   #9
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
Ok i was just looking at the my.cnf file under /etc

I use WinSCP alot to edit things, seems to be easier..

I give it ago and see what happens.

TT
 
Old 02-02-2004, 03:09 AM   #10
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
nar its still there.

i added skip-innodb to the mysql section..

TT
 
Old 02-02-2004, 03:25 AM   #11
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
well its got me stuffed now

here is what i done, i dont know if its the right way or what.
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
skip-innodb <----this is what i added.

[mysql.server]
user=mysql
basedir=/var/lib

[safe_mysqld]
err-log=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid


TT
 
Old 02-02-2004, 03:27 AM   #12
snacky
Member
 
Registered: Feb 2004
Distribution: Debian
Posts: 286

Rep: Reputation: 30
Er, what happens now? What error message? And does mysql run and connect, or not?
 
Old 02-02-2004, 03:33 AM   #13
tommytomato
Member
 
Registered: Nov 2003
Location: Narrogin Western Australia
Distribution: GUI Ubuntu 12.04 - Server 12.04.4 LTS
Posts: 939

Original Poster
Rep: Reputation: 32
hi mate

same error message as the above post,

mysql seems to be find and its running.
on the boot up it hangs for some time on the mysql and still shows time out error trying to start mysql demon.


well i got putty up to get the error message
( Timeout error occurred trying to start MySQL Daemon. )
TT

Last edited by tommytomato; 02-02-2004 at 03:35 AM.
 
  


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 03:13 PM
ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. suziecorbett Linux - Software 8 10-09-2008 02:52 AM
Starting MySQL OLD Error : imeout error occurred trying to start MySQL Daemon Fr33B5D Linux - Software 9 10-28-2006 07:23 AM
mysql error Can't connect to local MySQL server through socket '/var/lib/mysql/mysql. Dannux Linux - Software 3 03-24-2006 09:44 AM
mysql error on boot up tommytomato Linux - Newbie 1 02-03-2004 09:03 PM


All times are GMT -5. The time now is 01:13 AM.

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