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

Not without the error messages, we can't tell.

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

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

Yep thats it

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

TT

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...)

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

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...

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

nar its still there.

i added skip-innodb to the mysql section..

TT

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

Er, what happens now? What error message? And does mysql run and connect, or not?

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