I am trying to start MySQL on CentOS so I run service mysqld start but I get the following error:

Timeout error occurred trying to start MySQL Daemon

When I look into the logs, this is what I get

101015 11:06:08  mysqld started
101015 11:06:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101015 11:06:08 [Warning] option 'max_join_size': unsigned value 18446744073709551615 adjusted to 4294967295
101015 11:06:08 [ERROR] /usr/libexec/mysqld: unknown variable 'table_open_cache=256'
101015 11:06:08  mysqld ended

Can anyone tell me what is going wrong?

link|improve this question
feedback

1 Answer

What version MySQL are you running? Did you perhaps run into this bug?

link|improve this answer
I am running MySQL 5.1.x but I will check that link you sent right now. – user57194 Oct 15 '10 at 2:15
Now, I can't even connect to mysql. I get ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2) – user57194 Oct 15 '10 at 2:39
Well from your log message above, it looks like mysql is starting, throwing that error, and quitting, so it stands to reason that you wouldn't be able to connect. – ErikA Oct 15 '10 at 2:42
feedback

Your Answer

 
or
required, but never shown