Searched query: +mysql +can't +start
:MainNT
echo Installing MySQL as an Service
copy "%cd%\bin\my.cnf" /-y %windir%\my.ini
bin\mysqld --install mysql --defaults-file="%cd%\bin\my.cnf"
echo Try to start the MySQL deamon as service ...
net start MySQL
Reading the forum Announcement may help you to understand how to use the forum search facility correctly and being a new Apache Friends forum user it is the best place to start as answering the same questions over and over is quite a tedious task.segelwindhose wrote:Izzy - things will not become fixed if telling people to use the search engine.
Even the successful solutions in this post which is only a few posts down the forum list of topics didn't help?:segelwindhose wrote:There are more than three topics in the english and german forum about this problem
The number of comments (not fixes) is even higher, I've read and tried all !
No solution reported yet ... except GODLIKE who fixed but didn't respond how exactly.
Wiedmann's fix list I do believe which looks to me like a general cumulative check list of past known fixes - individual circumstances and PC conditions are not taken into account - flexibility is the name of the game with all things MS.segelwindhose wrote:To be honest: your fix does not work - especially at my machine: XP SP3, fresh and new
..and sc delete mysql at a command prompt not working either - deleting or uninstalling services will only be effective if a service is installed in the first place and for some registry issue can't be uninstalled in the usual manner.segelwindhose wrote:When went through the post in the forum, there is one commonality: XP with SP3, e.g.
All install and uninstall .bat does not work ! Unchecking boxes in the xampp does not work too !
Killing services does not work !
Using the installer version are you, perhaps?segelwindhose wrote:Just installing xampp out of the box and starting service does not work on XP SP3
Please do that so it may help others like you that seem unable to find a suitable solution from the many previously posted on the forums.segelwindhose wrote:Right now, I'm going to read and search the solution, will inform in case of substantial progress.
Diese Eingabeforderung nicht waehrend des Running beenden
Please dont close Window while MySQL is running
MySQL is trying to start
Please wait ...
MySQL is starting with mysql\bin\my.cnf (console)
090122 12:49:23 InnoDB: Started; log sequence number 0 46409
090122 12:49:23 [Note] Event Scheduler: Loaded 0 events
090122 12:49:23 [Note] mysql\bin\mysqld: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL
)
090122 9:33:37 InnoDB: Started; log sequence number 0 46409
090122 9:33:37 [Note] Event Scheduler: Loaded 0 events
090122 9:33:37 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)
090122 12:37:03 [Note] c:\xampp\mysql\bin\mysqld.exe: Normal shutdown
090122 12:37:03 [Note] Event Scheduler: Purging the queue. 0 events
090122 12:37:03 InnoDB: Starting shutdown...
090122 12:37:03 InnoDB: Shutdown completed; log sequence number 0 46409
090122 12:37:03 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete
[Thu Jan 22 09:18:37 2009] [notice] Digest: generating secret for digest authentication ...
[Thu Jan 22 09:18:37 2009] [notice] Digest: done
[Thu Jan 22 09:18:37 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Thu Jan 22 09:18:37 2009] [notice] Server built: Dec 10 2008 00:10:06
[Thu Jan 22 09:18:37 2009] [notice] Parent: Created child process 5300
[Thu Jan 22 09:18:38 2009] [notice] Digest: generating secret for digest authentication ...
[Thu Jan 22 09:18:38 2009] [notice] Digest: done
[Thu Jan 22 09:18:38 2009] [notice] Child 5300: Child process is running
[Thu Jan 22 09:18:38 2009] [notice] Child 5300: Acquired the start mutex.
[Thu Jan 22 09:18:38 2009] [notice] Child 5300: Starting 250 worker threads.
[Thu Jan 22 09:18:38 2009] [notice] Child 5300: Starting thread to listen on port 443.
[Thu Jan 22 09:18:38 2009] [notice] Child 5300: Starting thread to listen on port 80.
Application Error
und bei den Einzelheiten:
Fehlgeschlagene Anwendung mysqld.exe, Version 0.0.0.0, fehlgeschlagenes Modul mysqld.exe, Version 0.0.0.0, Fehleradresse 0x002b8853.
Fehler Service ControlManager
und bei den Einzelheiten
Dienst "mysql" wurde unerwartet beendet. Dies ist bereits 4 Mal passiert.
c:\xampp\mysql\bin\mysqld.exe: ready for connections.
Version: '5.1.30-community' socket: '' port: 3306 MySQL Community Server (GPL)
Off topic in here, start a new thread please.sunw wrote:When I run upgrade script for MySQL for webERP, and having problems with the foreign key creation:
CONSTRAINT `audittrail_ibfk_1` FOREIGN KEY (`userid`) REFERENCES
`www_users` (`userid`);
But, it is OK if the script run in XAMPP 1.64.
any clue?
Perhaps MySQL has not started.jim_genius5 wrote:It gives the following error message:
Error
MySQL said:
#2003 - The server is not responding
Connection for controluser as defined in your configuration failed.
Please revert to you default backup copy before following the above troubleshoot.jim_genius5 wrote:I do have a backup copy of it that I restore whenever an attempt fails.
Don't use the Admin... button that invokes WinMySQLAdmin as it is deprecated and should be removed from the XCP - it is causing so many request for support here.jim_genius5 wrote:...When launching the WinMySQLAdmin 1.4 through the XAMPP CP, it gives me the Access Violation message. It says:
Access Violation at address 1000A1F7 in module 'LIBMYSQL.dll'. Read of address 00000000.
This is not the recommended fix, see the search results mentioned above.jim_genius5 wrote:I did set a username and password other than the usual 'root' and 'nopassword' ones, but no luck. I had this problem in my 1.6.7 version, but I fixed it through the config.inc.php file.
Warning: file_get_contents(lang.tmp) [function.file-get-contents]: failed to open stream: No such file or directory in C:\xampp\htdocs\xampp\index.php on line 2
Warning: Cannot modify header information - headers already sent by (output started at C:\xampp\htdocs\xampp\index.php:2) in C:\xampp\htdocs\xampp\index.php on line 4
[Wed Jan 21 11:56:00 2009] [notice] Parent: Received shutdown signal -- Shutting down the server.
[Wed Jan 21 11:56:00 2009] [notice] Child 3476: Exit event signaled. Child process is ending.
[Wed Jan 21 11:56:01 2009] [notice] Child 3476: Released the start mutex
[Wed Jan 21 11:56:02 2009] [notice] Child 3476: All worker threads have exited.
[Wed Jan 21 11:56:02 2009] [notice] Child 3476: Child process is exiting
[Wed Jan 21 11:56:02 2009] [notice] Parent: Child process exited successfully.
[Wed Jan 21 11:56:08 2009] [notice] Apache/2.2.9 (Win32) DAV/2 mod_ssl/2.2.9 OpenSSL/0.9.8h mod_autoindex_color PHP/5.2.6 configured -- resuming normal operations
[Wed Jan 21 11:56:08 2009] [notice] Server built: Jun 14 2008 19:02:12
[Wed Jan 21 11:56:08 2009] [notice] Parent: Created child process 1328
[Wed Jan 21 11:56:10 2009] [notice] Child 1328: Child process is running
[Wed Jan 21 11:56:10 2009] [notice] Child 1328: Acquired the start mutex.
[Wed Jan 21 11:56:10 2009] [notice] Child 1328: Starting 250 worker threads.
[Wed Jan 21 11:56:10 2009] [notice] Child 1328: Starting thread to listen on port 443.
[Wed Jan 21 11:56:10 2009] [notice] Child 1328: Starting thread to listen on port 80.
Izzy wrote:Any help in these forum search results for php5ts (link) that you probably should have tried before posting your first message as outlined in the forum Announcements !!! Forum Search - Please Read First!!!.
What version of XAMPP?
Any more clues in the Windows Event Viewer?
Any clues in the Apache error.log file?
[Wed Jan 21 16:39:17 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:39:18 2009] [warn] pid file C:/xampp/apache/logs/httpd.pid overwritten -- Unclean shutdown of previous Apache run?
[Wed Jan 21 16:39:18 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:39:18 2009] [notice] Digest: done
[Wed Jan 21 16:39:21 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Wed Jan 21 16:39:21 2009] [notice] Server built: Dec 10 2008 00:10:06
[Wed Jan 21 16:39:21 2009] [notice] Parent: Created child process 4236
[Wed Jan 21 16:39:21 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:39:21 2009] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Jan 21 16:39:22 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:39:22 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:39:22 2009] [notice] Digest: done
[Wed Jan 21 16:39:23 2009] [notice] Child 4236: Child process is running
[Wed Jan 21 16:39:23 2009] [notice] Child 4236: Acquired the start mutex.
[Wed Jan 21 16:39:23 2009] [notice] Child 4236: Starting 250 worker threads.
[Wed Jan 21 16:39:23 2009] [notice] Child 4236: Listening on port 4499.
[Wed Jan 21 16:39:23 2009] [notice] Child 4236: Listening on port 9191.
[Wed Jan 21 16:40:29 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Wed Jan 21 16:40:30 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:40:30 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:40:30 2009] [notice] Digest: done
[Wed Jan 21 16:40:32 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Wed Jan 21 16:40:32 2009] [notice] Server built: Dec 10 2008 00:10:06
[Wed Jan 21 16:40:32 2009] [notice] Parent: Created child process 5624
[Wed Jan 21 16:40:32 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:40:32 2009] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Jan 21 16:40:33 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:40:34 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:40:34 2009] [notice] Digest: done
[Wed Jan 21 16:40:35 2009] [notice] Child 5624: Child process is running
[Wed Jan 21 16:40:35 2009] [notice] Child 5624: Acquired the start mutex.
[Wed Jan 21 16:40:35 2009] [notice] Child 5624: Starting 250 worker threads.
[Wed Jan 21 16:40:35 2009] [notice] Child 5624: Listening on port 4499.
[Wed Jan 21 16:40:35 2009] [notice] Child 5624: Listening on port 9191.
[Wed Jan 21 16:41:12 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Wed Jan 21 16:41:12 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:12 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:41:12 2009] [notice] Digest: done
[Wed Jan 21 16:41:13 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Wed Jan 21 16:41:13 2009] [notice] Server built: Dec 10 2008 00:10:06
[Wed Jan 21 16:41:13 2009] [notice] Parent: Created child process 2188
[Wed Jan 21 16:41:13 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:13 2009] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Jan 21 16:41:15 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:15 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:41:15 2009] [notice] Digest: done
[Wed Jan 21 16:41:16 2009] [notice] Child 2188: Child process is running
[Wed Jan 21 16:41:16 2009] [notice] Child 2188: Acquired the start mutex.
[Wed Jan 21 16:41:16 2009] [notice] Child 2188: Starting 250 worker threads.
[Wed Jan 21 16:41:16 2009] [notice] Child 2188: Listening on port 4499.
[Wed Jan 21 16:41:16 2009] [notice] Child 2188: Listening on port 9191.
[Wed Jan 21 16:41:25 2009] [notice] Parent: child process exited with status 3221225477 -- Restarting.
[Wed Jan 21 16:41:25 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:25 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:41:25 2009] [notice] Digest: done
[Wed Jan 21 16:41:26 2009] [notice] Apache/2.2.11 (Win32) DAV/2 mod_ssl/2.2.11 OpenSSL/0.9.8i mod_autoindex_color PHP/5.2.8 configured -- resuming normal operations
[Wed Jan 21 16:41:26 2009] [notice] Server built: Dec 10 2008 00:10:06
[Wed Jan 21 16:41:26 2009] [notice] Parent: Created child process 4416
[Wed Jan 21 16:41:26 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:26 2009] [notice] Disabled use of AcceptEx() WinSock2 API
[Wed Jan 21 16:41:27 2009] [warn] module php5_module is already loaded, skipping
[Wed Jan 21 16:41:27 2009] [notice] Digest: generating secret for digest authentication ...
[Wed Jan 21 16:41:27 2009] [notice] Digest: done
[Wed Jan 21 16:41:27 2009] [notice] Child 4416: Child process is running
[Wed Jan 21 16:41:27 2009] [notice] Child 4416: Acquired the start mutex.
[Wed Jan 21 16:41:27 2009] [notice] Child 4416: Starting 250 worker threads.
[Wed Jan 21 16:41:27 2009] [notice] Child 4416: Listening on port 4499.
[Wed Jan 21 16:41:27 2009] [notice] Child 4416: Listening on port 9191.
BTW WinMySQLAdmin is deprecated and the use of it in XAMPP is not recommended, use phpMyAdmin instead - a forum search for winmysqladmin may be fruitful for other alternatives.
It also sounds like you may have other issues with the XAMPP installation that is often fixed by uninstalling then doing a fresh install - make sure you backup your folders, files and databases before deleting the xampp folder ready for a fresh install.