WampServer

Hello everyone, first time posting as I can't figure out how to solve my WAMP/Wordpress problem.

Wamp ran just fine and from one day to the other I noticed MySQL doesn't start.


1. Windows 7 (64bit)
2. Wampversion 2.5 (64bit)
3. Apache 2.4.9 (Running just fine)
4. PHP 5.5.12
5. MySQL 5.6.17 (Not running)
6. WAMP Color Orange (Server Online)

- I tried running the MySQL service but nothing happens.
- I can go to localhost, but when i try to open my project path it says:
"Error establishing a database connection"
- I checked the PHP error log and this gave me this error, I have no clue what to do with it:

[08-May-2015 14:59:35 UTC] PHP Warning: PHP Startup: Unable to load dynamic library 'c:/wamp/bin/php/php5.5.12/ext/php_ldap.dll' - The specified module could not be found.

in Unknown on line 0


Hope someone can point me in the right direction as i've just finished my wordpress website



Edited 1 time(s). Last edit at 05/08/2015 05:12PM by MrSpanjaardd.

Hi,

- 1 - Wampmanager Icon->Apache->Version->2.4.9
This will create symbolic links that were missing after installation.

- 2 - WAMPServer 2.5 64bit MYSQL ONLY

The my.in file contains a woops! Edit the my.ini file using the wampmanager menus (wampmanager->MySQL->my.ini)

Locate this section header

[wampmysqld]

and change it to

[wampmysqld64]

- 3 - BEFORE you want to install and run Wordpress, you must be certain that Wampserver working properly, so having a green icon and have access to localhost and PhpMyAdmin.
It is not worth installing anything as long as the above conditions are not met; it will not function.

- 4 - Once WampServer will be fully functional, you can install Wordpress, but you must use a VirtualHost.
WAMPServer 2.5 The Homepage, Your Projects Menu and the need for Virtual Hosts

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

I tried running the steps you explained above but still the icon remains ORANGE.

The thing is, Wampserver ran fine and so I installed wordpress and made my website. It's only just since yesterday that the MySQL service won't start. I haven't made any system changes or anything so I have no idea what the cause is.

Help?

Hi,

See errors (Only errors because MySQL is a great talker!) in log file: wamp/logs/mysql.log and in the Event Viewer.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Did as you requested and finally I got a clear error message, any idea how to work from here? Your help is much appreciated!!

2015-05-10 01:22:39 6220 [Note] Plugin 'FEDERATED' is disabled.
2015-05-10 01:22:39 6220 [Note] InnoDB: Using atomics to ref count buffer pool pages
2015-05-10 01:22:39 6220 [Note] InnoDB: The InnoDB memory heap is disabled
2015-05-10 01:22:39 6220 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2015-05-10 01:22:39 6220 [Note] InnoDB: Compressed tables use zlib 1.2.3
2015-05-10 01:22:39 6220 [Note] InnoDB: Not using CPU crc32 instructions
2015-05-10 01:22:39 6220 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2015-05-10 01:22:39 6220 [Note] InnoDB: Completed initialization of buffer pool
2015-05-10 01:22:39 6220 [Note] InnoDB: Highest supported file format is Barracuda.
2015-05-10 01:22:39 6220 [Note] InnoDB: The log sequence numbers 1625977 and 1625977 in ibdata files do not match the log sequence number 15435978 in the ib_logfiles!
2015-05-10 01:22:39 6220 [Note] InnoDB: Database was not shutdown normally!
2015-05-10 01:22:39 6220 [Note] InnoDB: Starting crash recovery.
2015-05-10 01:22:39 6220 [Note] InnoDB: Reading tablespace information from the .ibd files...
2015-05-10 01:22:39 6220 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace test_db/wp_commentmeta uses space ID: 11 at filepath: .\test_db\wp_commentmeta.ibd. Cannot open tablespace thegooch_db/wp_commentmeta which uses space ID: 11 at filepath: .\thegooch_db\wp_commentmeta.ibd
InnoDB: Error: could not open single-table tablespace file .\thegooch_db\wp_commentmeta.ibd
InnoDB: We do not continue the crash recovery, because the table may become
InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
InnoDB: To fix the problem and start mysqld:
InnoDB: 1) If there is a permission problem in the file and mysqld cannot
InnoDB: open the file, you should modify the permissions.
InnoDB: 2) If the table is not needed, or you can restore it from a backup,
InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
InnoDB: crash recovery and ignore that table.
InnoDB: 3) If the file system or the disk is broken, and you cannot remove
InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
InnoDB: and force InnoDB to continue crash recovery here.

Hi,

If you have these errors - which are Worpress errors and not Wampserver errors - after launching Wampserver, it means that you modified the folder wamp/www/ and the index.php file located there is not the original one.

This is not what I asked you to do. I repeat:
BEFORE you want to install and run Wordpress, you must be certain that Wampserver working properly, so having a green icon and have access to localhost and PhpMyAdmin.
It is not worth installing anything as long as the above conditions are not met; it will not function.

---------------------------------------------------------------
Documentation Apache - Documentation PHP - Documentation MySQL - Wampserver install files & addons

Even though this is an old thread, I just wanted to say it helped me greatly.
Thank you so much Otomatic for figuring out what I've been stuck on for literally HOURS, going through HKEY_LOCAL_MACHINE even!

Great to see that you could figure it out, thanks indeed Otomatic!