Wampserver icon Orange - MySQL Service did not start
Posted by: jcmafra (---.40.158.118.static.host.gvt.net.br)
Date: April 19, 2015 01:36AM

Wampserver icon starts up red and then goes to orange. The icon does not reach green

- MySQL Service did not start

It began at morning, I unistall and install again 4 or 5 times (if you lease need

mora information of event viewer I can sand all as .evtx; .xml; .txt or csv file by

email.

Informations

1 - Windows 7 Professional Service Pack 1 - 64Bits
2 - wampserver2.5 - Apache-2.4.9 - Mysql-5.6.17 - php5.5.12 - 64b
3 - icon starts up red and then goes to orange. The icon does not reach green

Apache Erros Log:
[Sat Apr 18 18:55:35.367452 2015] [mpm_winnt:notice] [pid 2088:tid 384] AH00422:

Parent: Received shutdown signal -- Shutting down the server.
[Sat Apr 18 18:55:37.368566 2015] [mpm_winnt:notice] [pid 6728:tid 300] AH00364:

Child: All worker threads have exited.
[Sat Apr 18 18:55:37.384567 2015] [mpm_winnt:notice] [pid 2088:tid 384] AH00430:

Parent: Child process 6728 exited successfully.
[Sat Apr 18 18:55:52.814449 2015] [mpm_winnt:notice] [pid 7536:tid 384] AH00455:

Apache/2.4.9 (Win64) PHP/5.5.12 configured -- resuming normal operations
[Sat Apr 18 18:55:52.815449 2015] [mpm_winnt:notice] [pid 7536:tid 384] AH00456:

Apache Lounge VC11 Server built: Mar 16 2014 12:42:59
[Sat Apr 18 18:55:52.815449 2015] [core:notice] [pid 7536:tid 384] AH00094: Command

line: 'c:\\wamp\\bin\\apache\\apache2.4.9\\bin\\httpd.exe -d

C:/wamp/bin/apache/apache2.4.9'
[Sat Apr 18 18:55:52.821450 2015] [mpm_winnt:notice] [pid 7536:tid 384] AH00418:

Parent: Created child process 3276
[Sat Apr 18 18:55:53.313478 2015] [mpm_winnt:notice] [pid 3276:tid 300] AH00354:

Child: Starting 64 worker threads.

Apache Access Log:
127.0.0.1 - - [18/Apr/2015:17:38:56 -0300] "GET / HTTP/1.1" 200 4868

MySQL Log:
can't find c:\wamp\logs\mysql.log

PHP Error Log:
[18-Apr-2015 20:31:25 UTC] PHP Warning: PHP Startup: in Unknown on line 0[18-Apr-

2015 20:31:25 UTC] PHP Warning: PHP Startup: in Unknown on line 0[18-Apr-2015

20:31:26 UTC] PHP Warning: PHP Startup: in Unknown on line 0[18-Apr-2015 20:31:26

UTC] PHP Warning: PHP Startup: in Unknown on line 0[18-Apr-2015 21:55:21 UTC] PHP

Warning: PHP Startup: in Unknown on line 0[18-Apr-2015 21:55:21 UTC] PHP Warning:

PHP Startup: in Unknown on line 0[18-Apr-2015 21:55:21 UTC] PHP Warning: PHP

Startup: in Unknown on line 0[18-Apr-2015 21:55:21 UTC] PHP Warning: PHP Startup:

in Unknown on line 0[18-Apr-2015 21:55:52 UTC] PHP Warning: PHP Startup: in Unknown

on line 0[18-Apr-2015 21:55:52 UTC] PHP Warning: PHP Startup: in Unknown on line 0

[18-Apr-2015 21:55:53 UTC] PHP Warning: PHP Startup: in Unknown on line 0[18-Apr-

2015 21:55:53 UTC] PHP Warning: PHP Startup: in Unknown on line 0

++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Windows Event Viewer (last 12 hours - the "structure" of errors seems to be the same):

Erro 18/04/2015 18:55:53 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 18:55:53 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 18:55:53 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 18:55:21 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 18:55:21 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 18:55:21 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 18:34:19 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 18:34:19 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 18:34:19 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 18:34:02 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 18:34:02 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 18:34:02 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 18:32:37 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 18:32:37 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 18:32:37 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 17:38:43 MySQL 100 Nenhum
Erro 18/04/2015 17:38:43 MySQL 100 Nenhum
Erro 18/04/2015 17:38:43 MySQL 100 Nenhum
Erro 18/04/2015 17:31:52 MySQL 100 Nenhum
Erro 18/04/2015 17:31:52 MySQL 100 Nenhum
Erro 18/04/2015 17:31:52 MySQL 100 Nenhum
Erro 18/04/2015 17:31:26 MySQL 100 Nenhum
Erro 18/04/2015 17:31:26 MySQL 100 Nenhum
Erro 18/04/2015 17:31:26 MySQL 100 Nenhum
Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'file_instances' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'cond_instances' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'rwlock_instances' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'mutex_instances' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'file_summary_by_instance' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'file_summary_by_event_name' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_summary_global_by_event_name' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_summary_by_instance' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_summary_by_thread_by_event_name' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'threads' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'performance_timers' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'setup_timers' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'setup_instruments' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'setup_consumers' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_history_long' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_history' has the wrong structure

Erro 18/04/2015 13:30:20 MySQL 100 Nenhum
Native table 'performance_schema'.'events_waits_current' has the wrong structure

Erro 18/04/2015 13:15:43 MySQL 100 Nenhum
Aborting

Erro 18/04/2015 13:15:43 MySQL 100 Nenhum
Do you already have another mysqld server running on port: 3306 ?

Erro 18/04/2015 13:15:43 MySQL 100 Nenhum
Can't start server: Bind on TCP/IP port: No such file or directory

Erro 18/04/2015 13:09:38 MySQL 100 Nenhum
Erro 18/04/2015 13:09:38 MySQL 100 Nenhum
Erro 18/04/2015 13:09:38 MySQL 100 Nenhum
Erro 18/04/2015 13:08:56 MySQL 100 Nenhum
Erro 18/04/2015 13:08:56 MySQL 100 Nenhum
Erro 18/04/2015 13:08:56 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:53:52 MySQL 100 Nenhum
Erro 18/04/2015 12:47:27 MySQL 100 Nenhum
Erro 18/04/2015 12:47:27 MySQL 100 Nenhum
Erro 18/04/2015 12:47:27 MySQL 100 Nenhum
Erro 18/04/2015 12:46:59 MySQL 100 Nenhum
Erro 18/04/2015 12:46:59 MySQL 100 Nenhum
Erro 18/04/2015 12:46:59 MySQL 100 Nenhum
Erro 18/04/2015 12:40:39 MySQL 100 Nenhum
Erro 18/04/2015 12:40:39 MySQL 100 Nenhum
Erro 18/04/2015 12:40:39 MySQL 100 Nenhum
Erro 18/04/2015 12:39:40 MySQL 100 Nenhum
Erro 18/04/2015 12:39:40 MySQL 100 Nenhum
Erro 18/04/2015 12:39:40 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:19:23 MySQL 100 Nenhum
Erro 18/04/2015 12:13:17 MySQL 100 Nenhum
Erro 18/04/2015 12:13:17 MySQL 100 Nenhum
Erro 18/04/2015 12:13:17 MySQL 100 Nenhum
Erro 18/04/2015 12:12:34 MySQL 100 Nenhum
Erro 18/04/2015 12:12:34 MySQL 100 Nenhum
Erro 18/04/2015 12:12:34 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum
Erro 18/04/2015 09:06:11 MySQL 100 Nenhum

+++++++++++++++++++++++++++++++++++++++++++++++


file c:\Windows\System32\drivers\etc\hosts
127.0.0.1 localhost

+++++++++++++++++++++++++++++++++++++++++++++++


Please, how to solve it?

Options: ReplyQuote
Re: Wampserver icon Orange - MySQL Service did not start
Posted by: RiggsFolly (---.as43234.net)
Date: April 19, 2015 01:24PM

Well it looks like you have another instance of MYSQL running on your system.
You can run 2 or more MYSQL instances on your system, but you need to know what you are doing.

If you look in the Windows Services snapin ( services.msc ) you will probably see more than one MYSQL service.


WAMPServer installs MySQL as a service called wampmysqld so if you see a service called MYSQL then you have 2 instances installed.


I would suggest uninstalling the other MYSQL, but make sure you know why its there and do any backups that may be required before you uninstall it!

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Wampserver icon Orange - MySQL Service did not start
Posted by: jcmafra (---.98.14.dynamic.adsl.gvt.net.br)
Date: April 20, 2015 10:23PM

Through services.msc, I confirmed that there is a MySQL automatically instantiated. I do not know who or what did it.
I found, too, that there is no dependence for this service. Can I disable it and try to use the WAMP?

Options: ReplyQuote
Re: Wampserver icon Orange - MySQL Service did not start
Posted by: RiggsFolly (---.as43234.net)
Date: April 21, 2015 12:06AM

Yes.

Some Apps come with MYSQL installed under the covers so to speak, did you install MySQL Workbench by any chance? That can come with a MYSQL instance if you select the full version.

---------------------------------------------------------------------------------------------
(Windows 10 Pro 64bit) (Wampserver 3.3.4 64bit) Aestan Tray Menu 3.2.5.4
<Apache versions MULTIPE> <PHP versions MULTIPLE> <MySQL Versions MULTIPLE>
<MariaDB versions MULTIPLE> <phpMyAdmin versions MULTIPLE> <MySQL Workbench 8.0.23>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin
Get your Apache/MySQL/mariaDB/PHP ADDONs here from the WAMPServer alternate Repo
-X-X-X- Backup your databases regularly Here is How dont regret it later! Yes even when developing -X-X-X-

Options: ReplyQuote
Re: Wampserver icon Orange - MySQL Service did not start
Posted by: jcmafra (---.98.14.dynamic.adsl.gvt.net.br)
Date: April 21, 2015 12:35AM

Now working fine!
.
Thanks a lot.

I'll do some tests with some Apps and if I'll find out, I'll post here.

Options: ReplyQuote


Sorry, only registered users may post in this forum.