The service 'wampmysqld64' is NOT started - PLS HELP
Posted by: newtrarat (---.hsd1.ca.comcast.net)
Date: July 28, 2024 05:30AM

Hi guys, I'm doing an on premise wordpress migration from an old 32bit LAMP VM to a WAMP server running on Server 2016. I've had everything up and running and was doing the last bit of the migration this weekend. I'm not sure what the heck happened but all of a sudden, the mysql service will not start. If I try to start the service through windows I get an error message about the service starting and stopping and I'm getting this error in the MYSQL logs. The only thing I can think of that may have caused this was I used a plugin in wordpress to fix my image URL's. They were pointing to [localhost]. I've been using the site for several hours, doing some last minute customizations. Was ready to send the "I'm done e-mail" then bam. Started getting some PHP errors on one of my table plugins. I use a plugin called ninjatables to parse some company data. These have been working just fine for the last 4 or 5 hours. I got the php errors, went to restart the WAMP services and now the wampmysqld64 service will not start. The site is still sorta working, but i'm getting php errors on some of my pages because the services is not started Can anyone PLEASE HELP!!!!!!! Posting the whole log for clarity.

2024-07-28T02:22:06.570509Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2024-07-28T02:22:06.571050Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.
2024-07-28T02:22:06.612756Z 0 [System] [MY-010931] [Server] D:\wamp64\bin\mysql\mysql8.3.0\bin\mysqld.exe: ready for connections. Version: '8.3.0' socket: '' port: 3306 MySQL Community Server - GPL.
2024-07-28T02:22:30.468996Z 8 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:32.517693Z 9 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:36.569743Z 10 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:37.437116Z 11 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:42.441055Z 12 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:53.152708Z 13 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:53.870339Z 14 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:54.560111Z 15 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:57.372013Z 16 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:22:59.347400Z 17 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:03.134605Z 18 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:04.317560Z 19 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:10.121557Z 20 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:10.859395Z 21 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:10.886471Z 22 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:25.691277Z 23 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:48.119386Z 24 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:48.837123Z 25 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:49.531617Z 26 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:53.112267Z 27 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:58.261641Z 28 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:59.018613Z 29 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:23:59.040830Z 30 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:04.403448Z 31 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:07.519976Z 32 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:19.242369Z 33 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:46.625328Z 34 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:47.364351Z 35 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:48.475244Z 36 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:56.712566Z 37 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:57.877234Z 38 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:24:58.623416Z 39 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:35.331762Z 40 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:38.296928Z 41 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:39.251221Z 42 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:40.583183Z 43 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:57.735005Z 44 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:57.938098Z 45 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:25:58.438084Z 46 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:26:57.727139Z 47 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:26:58.384542Z 48 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:37.307062Z 49 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:39.053968Z 51 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:39.064316Z 50 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:52.840975Z 52 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:53.546681Z 53 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:27:57.715853Z 54 [Warning] [MY-013360] [Server] Plugin mysql_native_password reported: ''mysql_native_password' is deprecated and will be removed in a future release. Please use caching_sha2_password instead'
2024-07-28T02:28:41.433363Z 0 [System] [MY-013105] [Server] D:\wamp64\bin\mysql\mysql8.3.0\bin\mysqld.exe: Normal shutdown.
2024-07-28T02:28:42.324259Z 0 [System] [MY-010910] [Server] D:\wamp64\bin\mysql\mysql8.3.0\bin\mysqld.exe: Shutdown complete (mysqld 8.3.0) MySQL Community Server - GPL.
2024-07-28T02:28:42.325361Z 0 [System] [MY-015016] [Server] MySQL Server - end.
2024-07-28T02:36:53.361158Z 0 [System] [MY-015015] [Server] MySQL Server - start.
2024-07-28T02:36:53.640749Z 0 [System] [MY-010116] [Server] D:\wamp64\bin\mysql\mysql8.3.0\bin\mysqld.exe (mysqld 8.3.0) starting as process 11112
2024-07-28T02:36:53.710683Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2024-07-28T02:36:53.712214Z 1 [ERROR] [MY-012271] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2024-07-28T02:36:53.712759Z 1 [ERROR] [MY-012278] [InnoDB] The innodb_system data file 'ibdata1' must be writable
2024-07-28T02:36:53.713303Z 1 [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine
2024-07-28T02:36:53.714109Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2024-07-28T02:36:53.714627Z 0 [ERROR] [MY-010119] [Server] Aborting

Options: ReplyQuote
Re: The service 'wampmysqld64' is NOT started - PLS HELP
Posted by: Otomatic (Moderator)
Date: July 28, 2024 09:57AM

Hi,

Given that it comes from an "old 32bit LAMP VM", perhaps you shouldn't be using the latest version of MySQL, but an older version as well as PHP.

On the other hand: "The innodb_system data file 'ibdata1' must be writable" means that MySQL can't write to its own data folder. Are you the owner of the Wamp installation folder?

Windows Server 2016 is no longer supported.

- Verify that all VC ++ packages are installed and with the latest versions.
To do this, use the tool:
Checks VC++ packages installed
Do not use a previously loaded tool. Make a new download to make sure you are using the correct version.
Download packages on http://wampserver.aviatechno.net in section Visual C++ Redistribuable Packages
Do not forget that if you have a 64 bit Windows, you must install both 32 and 64 bit versions of each package.
You must install each package "as an administrator", so right-click the exe file and then run as Administrator.
To simplify things, see http://wampserver.aviatechno.net, at the bottom of the page, under :
Best way to install Visual C++ Redistributable Packages

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

Options: ReplyQuote


Sorry, only registered users may post in this forum.