WampServer

I just have installed the latest WAMPserver according the descriptions.
But I can't get mysql service to run.
Removed it, and installed it again, no result.
My OS: Windows 7 Home 32 bit

Please give my some help.
TIA!

Cor
The Netherlands



Edited 1 time(s). Last edit at 11/28/2014 10:32AM by Otomatic.

Hi Cor

Please answer these questions [forum.wampserver.com] there are also some troubleshooting tips in there.

The normal reasons for MySQL not starting are :-

1. You already have an instalnce of MySQL on your system that is Autostarting and therefore grabs port 3306 before WAMP's MySQL starts

2. You have installed MySQL in that past and the my.ini or my.cnf file from that install is still in the C:\windows folder structure somewhere.

3. Also check that an old/other MySQL has not added anything to your PATH. WAMPServer does not do this and there is no good reason for it being there.

---------------------------------------------------------------------------------------------
(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-

Thank you for reacting!!

OK, I checked and indeed there was a my.ini.
I renamed my_old.ini en rebooted my computer.
Started WAMP
Apache service runs, no problems
MySQL service still does not start.
mysql.log:
2014-11-28 13:11:09 5484 [Note] Plugin 'FEDERATED' is disabled.
2014-11-28 13:11:09 16e0 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
2014-11-28 13:11:09 5484 [Note] InnoDB: Using atomics to ref count buffer pool pages
2014-11-28 13:11:09 5484 [Note] InnoDB: The InnoDB memory heap is disabled
2014-11-28 13:11:09 5484 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2014-11-28 13:11:09 5484 [Note] InnoDB: Compressed tables use zlib 1.2.3
2014-11-28 13:11:09 5484 [Note] InnoDB: Not using CPU crc32 instructions
2014-11-28 13:11:09 5484 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2014-11-28 13:11:09 5484 [Note] InnoDB: Completed initialization of buffer pool
2014-11-28 13:11:09 16e0 InnoDB: Operating system error number 3 in a file operation.
InnoDB: The error means the system cannot find the path specified.
InnoDB: If you are installing InnoDB, remember that you must create
InnoDB: directories yourself, InnoDB does not create them.
2014-11-28 13:11:09 5484 [ERROR] InnoDB: File C:\mysql\data\ibdata1: 'create' returned OS error 103. Cannot continue operation

And the PHP error log shows:
[28-Nov-2014 11:19:52 Europe/Paris] PHP Deprecated: mysql_connect(): The mysql extension is deprecated and will be removed in the future: use mysqli or PDO instead in C:\wamp\www\testmysql.php on line 2

[28-Nov-2014 11:19:52 Europe/Paris] PHP Stack trace:

[28-Nov-2014 11:19:52 Europe/Paris] PHP 1. {main}() C:\wamp\www\testmysql.php:0

[28-Nov-2014 11:19:52 Europe/Paris] PHP 2. mysql_connect() C:\wamp\www\testmysql.php:2

[28-Nov-2014 11:19:53 Europe/Paris] PHP Warning: mysql_connect(): No connection could be made because the target machine actively refused it.

in C:\wamp\www\testmysql.php on line 2

[28-Nov-2014 11:19:53 Europe/Paris] PHP Stack trace:

[28-Nov-2014 11:19:53 Europe/Paris] PHP 1. {main}() C:\wamp\www\testmysql.php:0

[28-Nov-2014 11:19:53 Europe/Paris] PHP 2. mysql_connect() C:\wamp\www\testmysql.php:2

[28-Nov-2014 14:19:15 Europe/Paris] PHP Warning: mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it.


Any ideas??



Edited 1 time(s). Last edit at 11/28/2014 02:24PM by codo.

You did not read the post I pointed you to, and did not answer the questions in that post !!!

Please do that first.

---------------------------------------------------------------------------------------------
(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-

Thanks!

I did read the page and followed every step!
I thougt my response explained it.
I am Dutch so maybe I didn't understand you correctly.
Sorry!

1. Windows 7 Home 32 bit
2. Wampserver (32 bits & PHP 5.5) 2.5
3. Apache 2.4.9
4. PHP 5.5.12
5. MySQL 5.6.17
6. My icon is orange.
Eventviewer:
InnoDB: File C:\mysql\data\ibdata1: 'create' returned OS error 103. Cannot continue operation

7. These lines:
127.0.0.1 localhost
::1 localhost
127.0.0.1 activate.adobe.com
127.0.0.1 digi.localhost
127.0.0.1 localhost127.0.0.1 localhost127.0.0.1 localhost

8. Localhost works
9. PHP not, mysql error:
#2002 - No connection could be made because the target machine actively refused it.
The server is not responding (or the local server's socket is not correctly configured).

10. copied all above and in prior mail
11. AVG, Windows Firewaal and Emsosoft Anti Malware are running

Quote

6. My icon is orange.
Eventviewer:
InnoDB: File C:\mysql\data\ibdata1: 'create' returned OS error 103. Cannot continue operation

This is the problem C:\mysql\data\ibdata1

WampServer should not and wolud not normally be looking at this folder. Anything WAMPServer related should live under the \wamp\ folder somewhere.

So you still have a rough my.ini somewhere

This is the order that MySQL uses to find its my.ini file

%PROGRAMDATA%\MySQL\MySQL Server 5.6\my.ini
%WINDIR%\my.ini
C:\my.ini
INSTALLDIR\my.ini
defaults-extra-file	The file specified with --defaults-extra-file=path, if any
%APPDATA%\MySQL\.mylogin.cnf

So search your system for any other my.ini files ANYWHERE and rename/delete them unless they are in
\wamp\bin\mysql\mysql{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-

I have scanned aal and indeed there were 2 my.ini files in my wamp_old folders.
I removed the wamp_old completely and rebooted my system.

In the eventviewer it still reports:
InnoDB: File C:\mysql\data\ibdata1: 'create' returned OS error 103. Cannot continue operation

The files in the wamp_old will not be the problem, as those directories are not on any search path.


Something somewhere on your system is pointing MySQL at a my.ini that has that folder name in it and it should not be looking there

---------------------------------------------------------------------------------------------
(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-



Edited 1 time(s). Last edit at 11/28/2014 08:41PM by RiggsFolly.

I have deleted every my.ini except the one in the latest install.
I have no idea what or where could be anything pointing to mysql?

Does a new install help?

FOUND IT!!!

I uncommented a line in the new my.ini to use INNODB.

It's offcial now: I AM AN IDIOT!

Thank you very much for all your persisting help!!!!

[shame][shame][deep shame]

I hope you can except my humble apology!

Best regards
Cor

Cor,

No problem, we have al been there !

---------------------------------------------------------------------------------------------
(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-