Jump to content

Archived

This topic is now archived and is closed to further replies.

slobjones

MySQL keeps turning itself off

Recommended Posts

I can't keep MySQL running. I start it, it turns itself off. This started today, after a week with no problems.

I've tried it with installations of EasyPHP and now XAMPP. Same problem. I've tried removing the whole thing and reinstalling. Nothing changes.

Could there be some MySQL configuration files on my system that I'm missing?

Thanks.

Share this post


Link to post
Share on other sites
Check the error log, and post whatever messages appear in said log.

Share this post


Link to post
Share on other sites
[!--quoteo(post=372938:date=May 10 2006, 10:26 AM:name=fenway)--][div class=\'quotetop\']QUOTE(fenway @ May 10 2006, 10:26 AM) [snapback]372938[/snapback][/div][div class=\'quotemain\'][!--quotec--]
Check the error log, and post whatever messages appear in said log.
[/quote]

Here's a nice, fresh error log. I started XAMPP Control Panel, performed a refresh and status check and got this in the error log:

[Wed May 10 13:07:47 2006] [crit] (22)Invalid argument: unable to replace stderr with error_log
[Wed May 10 13:07:47 2006] [crit] (2)No such file or directory: unable to replace stderr with /dev/null
[Wed May 10 13:07:54 2006] [crit] (22)Invalid argument: unable to replace stderr with error_log
[Wed May 10 13:07:54 2006] [crit] (2)No such file or directory: unable to replace stderr with /dev/null
[Wed May 10 13:08:06 2006] [notice] Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.2 configured -- resuming normal operations
[Wed May 10 13:08:06 2006] [notice] Server built: Dec 1 2005 18:36:53
[Wed May 10 13:08:06 2006] [notice] Parent: Created child process 1244
[Wed May 10 13:08:22 2006] [notice] Child 1244: Child process is running
[Wed May 10 13:08:22 2006] [notice] Child 1244: Acquired the start mutex.
[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting 250 worker threads.
[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting thread to listen on port 443.
[Wed May 10 13:08:22 2006] [notice] Child 1244: Starting thread to listen on port 80.

I've found now that if I run XAMPP-restart, MySQL will operate, even though XAMPP-restart first reports: "Can't connect to MySQL server on localhost (10061)."

A check of the error log then shows:

[Wed May 10 13:12:57 2006] [notice] Apache/2.2.0 (Win32) DAV/2 mod_ssl/2.2.0 OpenSSL/0.9.8a mod_autoindex_color PHP/5.1.2 configured -- resuming normal operations
[Wed May 10 13:12:57 2006] [notice] Server built: Dec 1 2005 18:36:53
[Wed May 10 13:12:57 2006] [notice] Parent: Created child process 5648
[Wed May 10 13:13:30 2006] [notice] Child 5648: Child process is running
[Wed May 10 13:13:30 2006] [notice] Child 5648: Acquired the start mutex.
[Wed May 10 13:13:30 2006] [notice] Child 5648: Starting 250 worker threads.
[Wed May 10 13:13:31 2006] [notice] Child 5648: Starting thread to listen on port 443.
[Wed May 10 13:13:31 2006] [notice] Child 5648: Starting thread to listen on port 80.

XAMPP Control Panel reports:

ERROR: Status Check Failure [1]
ERROR: Status Check Failure [2]

But at that point, I can run localhost in my browser and MySQL operates with no problem. So maybe I should just run it this way and ignore the error messages.

Share this post


Link to post
Share on other sites
Well, that's not a MySQL error log; and the fact that it thinks it can't connect is definitely a problem.

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.