I have spent hours trying to get the server running (for the first time), trying many solutions posted online, but to no success.
First time install (Win 7 x64), light remains orage (server offline). If I look at service, the start/resume service remains green:
If I go in services and try start
wampmysqld64 service I get this error message:
Here is the Event Viewer Application log (the WAMP mysql log is empty):
Error 11/09/2015 09:04:22 MySQL 100 None Aborting Error 11/09/2015 09:04:22 MySQL 100 None Unknown/unsupported storage engine: InnoDB Error 11/09/2015 09:04:22 MySQL 100 None Plugin 'InnoDB' registration as a STORAGE ENGINE failed. Error 11/09/2015 09:04:22 MySQL 100 None Plugin 'InnoDB' init function returned error. Error 11/09/2015 09:04:22 MySQL 100 None InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data! Error 11/09/2015 09:04:22 MySQL 100 None InnoDB: space header page consists of zero bytes in data file .ibdata1 Warning 11/09/2015 09:04:22 MySQL 100 None InnoDB: Doublewrite does not have page_no=0 of space: 0
I haven’t removed/deleted any files, but I did install WAMP server on my
D drive (OS on
C) due to space limitations).
Installing WAMPServer on the D: drive is just fine.
Possibly somehow these files have been corrupted so try deleting them.
Delete these files, as this is an initial install they will not have any data in them and the restart of WAMPServer should cause MYSQL to re-create them.
wampinmysqlmysql5.6.17dataib_logfile0 wampinmysqlmysql5.6.17dataib_logfile1 wampinmysqlmysql5.6.17dataibdata1
Now for a little bug fix: Edit
Find the section marker
[wampmysqld] and change it to
Also if you are a little short of memory adding this parameter to the
my.ini file inside the
[wampmysqld64] will reduce the MYSQL memory requirement. Later versions of MYSQL seem to use a hugh amounts of memory ( half a gig ) lots of which is the
table_definition_cache for MYISAM files, this will reduce it to something sensible and not effect your use of MYISAM files.
[wampmysqld64] table_definition_cache = 600
In my case I just had to: edit
wampinmysqlmysql5.6.17my.ini and find the section
[wampmysqld] and change it to
Then I restarted mysql and it worked!
For me, I realised that I had another MySQL program (from Oracle) installed that was causing a common port-use conflict. Uninstall/disable MySQL server/workbench and other MySQL programs then restart WAMP. This might solve the problem, it worked for me.
I also uninstalled and deleted an old version of WAMP before installing the latest version.
WAMP is a less stable platform. I would suggest XAMPP over WAMP.
It is light compared to wamp-server and much stable than WAMP.
XAMPP is more powerful and resource taking than WAMP.
WAMP provides support for MySQL and PHP.
XAMPP provides support for MYSQL, PHP and PERL
XAMPP also has SSL feature while WAMP doesn’t.
If your applications need to deal with native web apps only, Go for WAMP. If you need advanced features as stated above, go for XAMPP.
As of priority, you cant run both together with default installation as XAMPP gets a higher priority and it takes up ports. So WAMP can’t be run in parallel with XAMPP.
- If mysql service is not starting open
my.inifile located at
- Change port number to 3305 at 3 location:
#password = your_password port = 3305 socket = /tmp/mysql.sock
# The MySQL server [wampmysqld] port = 3305
- Now go to
config.inc.phpand change this line:
$cfg['Servers'][$i]['port'] = '3306';
$cfg['Servers'][$i]['port'] = '3305';
(3305 being the port you selected previously).
Those steps should get your MySQL running.