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.
