Timeout error occurred trying to start MySQL Daemon

[Mat]

Hi,

--
I tried to ask this question in the software section, but it wen't unanswered.. perhaps here's a better place to try?!..
--


I'm using FC2 and recently updated to MySQL 3.23.58. Since that update, I get the error mentioned in the title.. However, the daemon is started and I can access the db without problems. It also takes a litte longer to start, so I guess there's really a time-out, I just don't have a clue where...

looking in /var/log/mysqld.log

041122 00:26:09 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


so besides the InnoDB stuff, there's no error... and even after temporarely adding the innodb_path, the "error" still exists..


any ideas?

Mat

[Mat]

I've found the solution.. so if anyone's interested, here it is:

the reason for this is the removal of anonymous users. the start-up script uses "/usr/bin/mysqladmin ping" to check whether the process is running. If you restricted access to the database to people with passwords, this will unevitably fail.

so here are the steps to solve it:

edit "/etc/init.d/mysqld" as follows

- ping="/usr/bin/mysqladmin -uUNKNOWN_MYSQL_USER ping"
+ ping="/usr/bin/mysqladmin -u<USER> -p<PASSWORD> ping"


and change <USER> and <PASSWORD> to a specific user (you should not use root, better create a dummy user with no privileges for that)..

note: there's no white spaces between -u and the username, neither between -p and the password.



Mat