Fedora Linux Support Community & Resources Center
  #1  
Old 23rd November 2004, 01:35 PM
Mat Offline
Retired Community Manager
 
Join Date: Jun 2004
Location: lair of a unix daemon
Posts: 1,155
Timeout error occurred trying to start MySQL Daemon

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
Code:
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
__________________
Man will always find a difficult means to perform a simple task
(Rube Goldberg)

Having fun with Tcl at
Mat's Playground
Reply With Quote
  #2  
Old 15th December 2004, 12:48 PM
Mat Offline
Retired Community Manager
 
Join Date: Jun 2004
Location: lair of a unix daemon
Posts: 1,155
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
Code:
- 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
__________________
Man will always find a difficult means to perform a simple task
(Rube Goldberg)

Having fun with Tcl at
Mat's Playground
Reply With Quote
Reply

Tags
daemon, error, mysql, occurred, start, timeout

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
MySQL gives me the fallowing error "ERROR 1049 (42000): Unknown database 'start'" Rockafella Using Fedora 2 2nd July 2006 08:17 AM
MySQL-server-4.1.10a-0 ERROR 2002 (HY000) Start up problem DoorGunner Servers & Networking 3 7th April 2005 07:13 PM
Timeout error occurred trying to start MySQL Daemon Mat Using Fedora 0 21st November 2004 11:33 PM


Current GMT-time: 09:11 (Thursday, 29-06-2017)

TopSubscribe to XML RSS for all Threads in all ForumsFedoraForumDotOrg Archive
logo

All trademarks, and forum posts in this site are property of their respective owner(s).
FedoraForum.org is privately owned and is not directly sponsored by the Fedora Project or Red Hat, Inc.

Privacy Policy | Term of Use | Posting Guidelines | Archive | Contact Us | Founding Members

Powered by vBulletin® Copyright ©2000 - 2012, vBulletin Solutions, Inc.

FedoraForum is Powered by RedHat