MySQL Service Will No Longer Start
Posted by: Testuda (---.cpe.teksavvy.com)
Date: April 29, 2017 01:28AM

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.

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: RiggsFolly (Moderator)
Date: April 29, 2017 03:58AM

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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: Testuda (---.cpe.teksavvy.com)
Date: April 29, 2017 03:56PM

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'

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: RiggsFolly (Moderator)
Date: April 29, 2017 04:24PM

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 7 Pro 32bit) (Wampserver 3.0.6 32bit)
<Apache 2.4.23/2.2.31> <PHP 7.1.2/7.0.16/5.6.28/5.5.38/5.4.45/5.3.29> <MySQL 5.7.10/5.6.17/5.5.28>
<MariaDB 10.1.21> <phpMyAdmin4.7.5> <MySQL Workbench 6.3.6.511>

Read The Manuals Apache -- MySQL -- PHP -- phpMyAdmin -- WAMPServer alternate Repo
-?-?-?- Backup your MySQL databases regularly Here is How dont regret it later! Yes even when developing -?-?-?-

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: Testuda (---.cpe.teksavvy.com)
Date: April 29, 2017 05:51PM

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.

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: Testuda (---.cpe.teksavvy.com)
Date: April 29, 2017 06:10PM

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


:'(

Options: ReplyQuote
Re: MySQL Service Will No Longer Start
Posted by: Testuda (---.cpe.teksavvy.com)
Date: April 29, 2017 06:55PM

I FIXED IT.

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.