WampServer

Hello,
I have been successfully using WAMP for months now, until I finally tried to log in to phpMyAdmin. I went through the rigmarole of re-setting my password, which took several tries, but I was finally able to log on.

After then following the instructions found here: [www.wpexplorer.com] -- I tried both methods because the first one didn't seem to work -- MySQL Service will not start. Here is the most recent log:

2017-04-28T21:34:32.650184Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-04-28T21:34:32.684443Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-04-28T21:34:32.685443Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-04-28T21:34:32.685944Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-04-28T21:34:33.016913Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-04-28T21:34:33.017402Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-04-28T21:34:33.017902Z 0 [ERROR] Failed to initialize plugins.
2017-04-28T21:34:33.017902Z 0 [ERROR] Aborting

I am running Windows 10 64-bit.
WampServer 3.0.6 32-bit

Apache 2.4.23
PHP 7.0.10
MySQL 5.7.14
PHP 5.6.25 for CLI (Command-Line Interface)
WampServer icon is orange.


Because I have been working on this for so many hours today, I'm afraid I can't even re-trace my steps any more.

Going to my website, everything is empty (because I was doing everything locally before). Trying to reach localhost, I get an "Error: Unable to Connect to Database" message.

Hi,

Sorry I am a bit confused.

Are you trying to move a WordPress site from your local machine to a LIVE hosted server, or move WordPress from a LIVE server to a local WAMPServer on your PC?

---------------------------------------------------------------------------------------------
(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 am trying to move the site from localhost to a live WordPress site.

I also just tested port 3306 and got this message:

***** Test which uses port 3306 *****

===== Tested by command netstat filtered on port 3306 =====


Test for TCP
Your port 3306 is used by a processus with PID = 10916
The processus of PID 10916 is 'mysqld.exe' Session: Console
The service of PID 10916 for 'mysqld.exe' is 'N/A'
*** ERROR *** This service IS NOT from Wampserver - Should be: 'wampmysqld'

Test for TCPv6
Your port 3306 is used by a processus with PID = 10916
The processus of PID 10916 is 'mysqld.exe' Session: Console
The service of PID 10916 for 'mysqld.exe' is 'N/A'
*** ERROR *** This service IS NOT from Wampserver - Should be: 'wampmysqld'

Where did you test this?

On the LIVE Server?

Whichever it is you have TWO MySQL Servers running.

As I dont know or suppost your LIVE Host, maybe you had better ask for help 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-

Right now I'm trying to connect to localhost so I can figure out why none of my changes are showing up on the live server. Apache is running, but MySQL gives me the error I showed you:

2017-04-29T15:45:55.016193Z 0 [Warning] 'NO_AUTO_CREATE_USER' sql mode was not set.
2017-04-29T15:45:55.042211Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-04-29T15:45:55.043211Z 0 [ERROR] InnoDB: The innodb_system data file 'ibdata1' must be writable
2017-04-29T15:45:55.044212Z 0 [ERROR] InnoDB: Plugin initialization aborted with error Generic error
2017-04-29T15:45:55.377033Z 0 [ERROR] Plugin 'InnoDB' init function returned error.
2017-04-29T15:45:55.377533Z 0 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-04-29T15:45:55.378034Z 0 [ERROR] Failed to initialize plugins.
2017-04-29T15:45:55.378034Z 0 [ERROR] Aborting

As for testing the port, I tested it locally.

OK OK So I got it to start again. I finally found where the incorrect mysqld.exe file was running and stopped it. I also deleted auto.cnf, xxxxxxxxx.err, xxxxxxxxx.pid, ib_logfile0 and ib_logfile1 from the data folder. HOWEVER, when I go to localhost in my browser, I get the following message:

Error establishing a database connection


:'(

I FIXED IT.

The wpconfig file was messed up. The remainder of my problems are WP-related, not Wamp.