MySQL is broken after updating the VC++ runtime 2013

What issue or error are you experiencing?

When loading a site with MySQL I am unable to open the site due to this error. mysqladmin ping failed because cannot load mysql on server at ::1 etc.

What steps can be taken to replicate the issue? Feel free to include screenshots, videos, etc

Start or create a new site using MySQL.
This problem started because another application needed to install a VC++ runtime (I think 2013). After this my install no longer worked.


System Details

  • Local Version:
    8.1.0+6514
  • Operating System (OS) and OS version:
    Windows 11

Local Logs

Attach your Local Logs here (Help Doc - Retrieving Local’s Log)

I dont see an attach option :-(. But here is some of the log as I had to cut it down to fit in this text box.

{“level”:“info”,“message”:“Finished maybeCopyBundledServices in 0.001s”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.893Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\mailhog-1.0.0+3\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.895Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\mailhog-1.0.0+3\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.897Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\mariadb-10.4.10+4\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.898Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\mariadb-10.4.10+4\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.932Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\mysql-8.0.16+6\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.933Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\mysql-8.0.16+6\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.964Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\nginx-1.16.0+7\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.965Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\nginx-1.16.0+7\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.992Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\php-8.1.23+0\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:02.993Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\php-8.1.23+0\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.023Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Loading Add-on: %%userDataPath%%\lightning-services\php-8.2.10+1\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.025Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Successfully Loaded Add-on: %%userDataPath%%\lightning-services\php-8.2.10+1\lib\main.js”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.060Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Add-on does not have "productName" specified in package.json: %%appPath%%\node_modules\@getflywheel\local-components\package.json”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.061Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Add-on does not have "productName" specified in package.json: %%appPath%%\node_modules\@getflywheel\localcert\package.json”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.061Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Add-on does not have "productName" specified in package.json: %%appPath%%\node_modules\@getflywheel\localtunnel\package.json”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.061Z”}
{“class”:“AddonLoaderService”,“level”:“info”,“message”:“Add-on does not have "main" or "renderer" specified in package.json: %%appPath%%\node_modules\@getflywheel\replacestream\package.json”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.062Z”}
{“class”:“GraphQLService”,“level”:“verbose”,“message”:“GraphQL server ready at http://127.0.0.1:4000/graphql",“thread”:“main”,“timestamp”:"2023-12-07T16:00:03.137Z”}
{“class”:“GraphQLService”,“level”:“verbose”,“message”:“GraphQL subscriptions ready at ws://127.0.0.1:4000/graphql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.138Z”}
{“level”:“warn”,“linuxEdition”:null,“localVersion”:“8.1.0+6514”,“message”:“Electron Event ready”,“osArch”:“x64”,“osPlatform”:“win32”,“osRelease”:“10.0.22621”,“timestamp”:“2023-12-07T16:00:03.294Z”,“windowsEdition”:“Microsoft Windows 11 Pro”}
{“class”:“Updater”,“level”:“info”,“message”:“Checking for updates for: win32-ia32-production”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.333Z”}
{“class”:“Updater”,“level”:“debug”,“message”:“Check for updates result”,“release”:null,“thread”:“main”,“timestamp”:“2023-12-07T16:00:03.887Z”}
{“class”:“ConfigTemplatesService”,“level”:“info”,“message”:“Compiling service configs…”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:09.892Z”}
{“class”:“Process”,“level”:“verbose”,“message”:“Spawned”,“pid”:10932,“process”:“mailhog”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:09.977Z”}
{“class”:“Process”,“level”:“verbose”,“message”:“Spawned”,“pid”:15600,“process”:“phpCgi”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:09.983Z”}
{“class”:“Process”,“level”:“verbose”,“message”:“Spawned”,“pid”:14128,“process”:“phpCgi”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:09.988Z”}
{“class”:“Process”,“level”:“verbose”,“message”:“Spawned”,“pid”:1804,“process”:“nginx”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:09.994Z”}
{“class”:“Process”,“level”:“verbose”,“message”:“Spawned”,“pid”:3448,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:10.000Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:10.094551Z 0 [System] [MY-010116] [Server] %%userDataPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe (mysqld 8.0.16) starting as process 1056”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.761Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:10.095946Z 0 [Warning] [MY-013243] [Server] --character-set-server: The character set UTF8MB3 is deprecated and will be removed in a future release. Please consider using UTF8MB4 instead.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.761Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:11.113351Z 0 [System] [MY-010229] [Server] Starting crash recovery…”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.761Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:11.120000Z 0 [System] [MY-010232] [Server] Crash recovery finished.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.761Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:11.723059Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.762Z”}
{“class”:“Process”,“level”:“warn”,“message”:“2023-12-07T16:00:11.760920Z 0 [System] [MY-010931] [Server] %%userDataPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqld.exe: ready for connections. Version: ‘8.0.16’ socket: ‘’ port: 10017 MySQL Community Server - GPL.”,“process”:“mysql”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:11.762Z”}
{“level”:“error”,“message”:“Database did NOT respond to ping after 15 tries.”,“service”:{},“serviceBinVersion”:{},“stack”:“Error: Command failed: %%userDataPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqladmin.exe ping\n\u0007mysqladmin: connect to server at ‘::1’ failed\r\nerror: ‘Can’t connect to MySQL server on ‘::1’ (10013)’\r\nCheck that mysqld is running on ::1 and that the port is 10017.\r\nYou can check this by doing ‘telnet ::1 10017’\r\n\n at ChildProcess.exithandler (node:child_process:430:12)\n at ChildProcess.emit (node:events:513:28)\n at maybeClose (node:internal/child_process:1091:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:18.320Z”}
{“class”:“SiteProcessManagerService”,“level”:“error”,“message”:“Unable to start site.”,“stack”:“Error: Command failed: %%userDataPath%%\lightning-services\mysql-8.0.16+6\bin\win64\bin\mysqladmin.exe ping\n\u0007mysqladmin: connect to server at ‘::1’ failed\r\nerror: ‘Can’t connect to MySQL server on ‘::1’ (10013)’\r\nCheck that mysqld is running on ::1 and that the port is 10017.\r\nYou can check this by doing ‘telnet ::1 10017’\r\n\n at ChildProcess.exithandler (node:child_process:430:12)\n at ChildProcess.emit (node:events:513:28)\n at maybeClose (node:internal/child_process:1091:16)\n at ChildProcess._handle.onexit (node:internal/child_process:302:5)”,“thread”:“main”,“timestamp”:“2023-12-07T16:00:18.321Z”}


Security Reminder
Local does a pretty good job of scrubbing private info from the logs and the errors it produces, however there’s always the possibility that something private can come through. Because these are public forums, always review the screenshots you are sharing to make sure there isn’t private info like passwords being displayed.

Hi @jeffh1 - thanks for reaching out! Sorry to hear you’re running into issues.

Is this for all of your sites, or just specific sites in particular? From the logs I can see, it looks like Local is either having trouble talking to MySQL or it isn’t actually running on the machine (something is preventing it from starting).

Seeing the full logs would be helpful - you can upload via this icon here:

Have you tried restarting the site and/or Local?

1 Like

I am currently in a learning stage with WordPress and was able to re-create what I need using the MarionDB. This will get me going with my education. I agree that MySQL is probably no longer running. I will investigate later and see if I can repeat the exact steps I took that broke the connection. I have a software package Clarion that uses the VC++ runtime and that program broke after I installed the about application. I need Clarion more than I need WordPress. I ran the install for Clarion which installed the VC++ runtime (I did not actually re-install clarion. I canceled the install after the runtime was installed). That fixed Clarion but broke the MySQL connection. If it helps any I posted the log file. Thanks for your help!

local-lightning-verbose.save.log (245.2 KB)

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.