Unable to start site - MySQL Error

What issue or error are you experiencing?

I am experiencing an issue with Local by Flywheel where MySQL fails to start, preventing me from accessing my local WordPress site. The error message states:

“Uh-oh! Unable to start site. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0.”

Additionally:

  • Reinstalling Local did not fix the problem.
  • No WordPress version is displayed in Local.

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


System Details

  • Local Version:

  • 9.2.2

  • Operating System (OS) and OS version:

  • windows 10 Home single Language 64 bit (10.0,Build 19045)


Local Logs

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


{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to getWordpressTranslations","stringifiedCallback":"() => __awaiter(this, void 0, void 0, function* () { return this.getWordpressTranslations(); })","thread":"main","timestamp":"2025-02-20T05:56:34.907Z"}
{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to connectManifestWpeService:create","stringifiedCallback":"(manifestRequestToken, direction, siteId, fullSync, wpengineSiteId, wpengineInstallName, wpengineInstallId, wpenginePrimaryDomain) => this.create(manifestRequestToken, direction, siteId, fullSync, wpengineSiteId, wpengineInstallName, wpengineInstallId, wpenginePrimaryDomain)","thread":"main","timestamp":"2025-02-20T05:56:34.925Z"}
{"level":"warn","linuxEdition":null,"localVersion":"9.2.2+6771","message":"Electron Event ready","osArch":"x64","osPlatform":"win32","osRelease":"10.0.19045","timestamp":"2025-02-20T05:56:50.089Z","windowsEdition":"Microsoft Windows 10 Home Single Language"}
{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to getWordpressTranslations","stringifiedCallback":"() => __awaiter(this, void 0, void 0, function* () { return this.getWordpressTranslations(); })","thread":"main","timestamp":"2025-02-20T05:56:49.288Z"}
{"class":"addIpcAsyncListener","level":"warn","message":"Duplicate callback appears to be getting added to connectManifestWpeService:create","stringifiedCallback":"(manifestRequestToken, direction, siteId, fullSync, wpengineSiteId, wpengineInstallName, wpengineInstallId, wpenginePrimaryDomain) => this.create(manifestRequestToken, direction, siteId, fullSync, wpengineSiteId, wpengineInstallName, wpengineInstallId, wpenginePrimaryDomain)","thread":"main","timestamp":"2025-02-20T05:56:49.310Z"}
{"level":"warn","linuxEdition":null,"localVersion":"9.2.2+6771","message":"Electron Event ready","osArch":"x64","osPlatform":"win32","osRelease":"10.0.19045","timestamp":"2025-02-20T05:56:52.407Z","windowsEdition":"Microsoft Windows 10 Home Single Language"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:43.178632Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:43.205Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:43.178680Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.35) starting as process 5852","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:43.206Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:43.188027Z 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":"2025-02-20T05:57:43.208Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:43.212241Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:43.213Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:43.231897Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:43.232Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:44.715321Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:44.715Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:46.283276Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:46.283Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:46.283437Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:46.285Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:46.319344Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '%%userDataPath%%\\run\\yYjV4qCfE\\mysql\\data\\????.pid' (OS errno 2 - No such file or directory)","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:46.320Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:46.321815Z 0 [ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:46.322Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:46.339675Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:46.340Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:47.715062Z 0 [System] [MY-010910] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:47.715Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:48.716361Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:48.731Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:48.716401Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.35) starting as process 3984","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:48.732Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:48.720667Z 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":"2025-02-20T05:57:48.734Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:48.738829Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:48.739Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:48.747285Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:48.748Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:49.720104Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:49.720Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:50.620163Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:50.620Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:50.620445Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:50.622Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:50.635725Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '%%userDataPath%%\\run\\yYjV4qCfE\\mysql\\data\\????.pid' (OS errno 2 - No such file or directory)","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:50.636Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:50.636413Z 0 [ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:50.638Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:50.648015Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:50.648Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:51.869824Z 0 [System] [MY-010910] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:51.870Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:52.648567Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:52.660Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:52.648605Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.35) starting as process 9028","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:52.661Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:52.652246Z 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":"2025-02-20T05:57:52.663Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:52.666494Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:52.666Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:52.673495Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:52.674Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:53.397999Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:53.398Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:54.346744Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:54.347Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:54.346997Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:54.349Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:54.361805Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '%%userDataPath%%\\run\\yYjV4qCfE\\mysql\\data\\????.pid' (OS errno 2 - No such file or directory)","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:54.362Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:54.361877Z 0 [ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:54.363Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:54.373563Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:54.374Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:55.590293Z 0 [System] [MY-010910] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:55.590Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:56.366839Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:56.377Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:56.366877Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.35) starting as process 7348","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:56.378Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:56.370052Z 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":"2025-02-20T05:57:56.379Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:56.382983Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:56.383Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:56.387532Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:56.387Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.138541Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.139Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.960337Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.960Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.960492Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.962Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.973705Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '%%userDataPath%%\\run\\yYjV4qCfE\\mysql\\data\\????.pid' (OS errno 2 - No such file or directory)","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.974Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.973768Z 0 [ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.975Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:57.982911Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:57.983Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:57:59.233060Z 0 [System] [MY-010910] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:57:59.233Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.134153Z 0 [Warning] [MY-010918] [Server] 'default_authentication_plugin' is deprecated and will be removed in a future release. Please use authentication_policy instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:00.144Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.134179Z 0 [System] [MY-010116] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe (mysqld 8.0.35) starting as process 8404","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:00.145Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.136772Z 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":"2025-02-20T05:58:00.147Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.151601Z 0 [Warning] [MY-013907] [InnoDB] Deprecated configuration parameters innodb_log_file_size and/or innodb_log_files_in_group have been used to compute innodb_redo_log_capacity=201326592. Please use innodb_redo_log_capacity instead.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:00.152Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.156341Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:00.156Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:00.828426Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:00.829Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:01.690487Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:01.691Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:01.690653Z 0 [System] [MY-013602] [Server] Channel mysql_main configured to support TLS. Encrypted connections are now supported for this channel.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:01.692Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:01.704771Z 0 [ERROR] [MY-013129] [Server] A message intended for a client cannot be sent there as no client-session is attached. Therefore, we're sending the information to the error-log instead: MY-000001 - Can't create/write to file '%%userDataPath%%\\run\\yYjV4qCfE\\mysql\\data\\????.pid' (OS errno 2 - No such file or directory)","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:01.705Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:01.704825Z 0 [ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:01.706Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:01.713752Z 0 [ERROR] [MY-010119] [Server] Aborting","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:01.714Z"}
{"class":"Process","level":"warn","message":"2025-02-20T05:58:02.955448Z 0 [System] [MY-010910] [Server] %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqld.exe: Shutdown complete (mysqld 8.0.35)  MySQL Community Server - GPL.","process":"mysql","thread":"main","timestamp":"2025-02-20T05:58:02.955Z"}
{"level":"error","message":"Database did NOT respond to ping after 5 tries on any address.","service":"mysql","serviceBinVersion":"8.0.35","stack":"Error: Command failed: %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqladmin.exe --host=::1 ping\n\u0007mysqladmin: connect to server at '::1' failed\r\nerror: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0'\r\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at maybeClose (node:internal/child_process:1098:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:303:5)","thread":"main","timestamp":"2025-02-20T05:58:02.966Z"}
{"class":"SiteProcessManagerService","level":"error","message":"Unable to start site.","stack":"Error: Command failed: %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqladmin.exe --host=::1 ping\n\u0007mysqladmin: connect to server at '::1' failed\r\nerror: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0'\r\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at maybeClose (node:internal/child_process:1098:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:303:5)","thread":"main","timestamp":"2025-02-20T05:58:02.968Z"}
{"class":"SiteProvisionerService","level":"error","message":"Unable to provision site.","stack":"Error: Command failed: %%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqladmin.exe --host=::1 ping\n\u0007mysqladmin: connect to server at '::1' failed\r\nerror: 'Lost connection to MySQL server at 'reading initial communication packet', system error: 0'\r\n\n    at ChildProcess.exithandler (node:child_process:422:12)\n    at ChildProcess.emit (node:events:517:28)\n    at maybeClose (node:internal/child_process:1098:16)\n    at ChildProcess._handle.onexit (node:internal/child_process:303:5)","thread":"main","timestamp":"2025-02-20T06:01:20.142Z"}
{"eventId":"1bca6a9a292b4cf8b4c33561115fdeba","level":"warn","message":"Unhandled Rejection.","p":{},"reason":{"cmd":"%%userDataPath%%\\lightning-services\\mysql-8.0.35+2\\bin\\win64\\bin\\mysqladmin.exe --host=::1 ping","code":1,"killed":false,"signal":null},"thread":"main","timestamp":"2025-02-20T06:01:20.830Z"}

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.

Welcome, @Faysal_Shipu, and thanks for this report.

Your logs show that MySQL can’t write to a directory it needs write access to:

[ERROR] [MY-013129] [Server] Can't create/write to file ‘%%userDataPath%%\run\yYjV4qCfE\mysql\data\???.pid’ (OS errno 2 - No such file or directory)

[ERROR] [MY-010092] [Server] Can't start server: can't create PID file: No such file or directory

This can happen due to antivirus or security software that sometimes prevents Local and MySQL from writing files.

There are some extra tips here that can help with permissions issues on Windows:

I am still facing the same problem—I cannot create a new site due to this issue. I have followed every step you mentioned, but nothing has worked. I am exhausted from trying to solve this problem, as I have been dealing with it for almost 15 days.

Sorry for the trouble you’ve had with this, @Faysal_Shipu, I completely understand your frustration.

So far I cannot reproduce the error you see with Local 9.2.2 on Windows.

Do you have plenty of free disk space?

Are you running Local as an admin user?

Thank you for your response.

  • I have around 10GB of free disk space available.
  • I am running LocalWP as an administrator
  • I have also tried disabling my antivirus and firewall, but the issue persists.

Do you have any other suggestions or troubleshooting steps I should try?

Thanks again for your help!

Thanks for that info, @Faysal_Shipu!

Let’s first check if this is specific to MySQL 8.0.35 (the latest version of MySQL that Local supports).

You can do that by trying to create a site using the previous version, MySQL 8.0.16:

  1. Click the + button (bottom left) to add a new site.
  2. Choose “Create a new site” and click “Continue”.
  3. Give the site a name and click “Continue”.
  4. Change from “Preferred” to “Custom”.
  5. Choose 8.2.23 for the PHP version, nginx for the web server, and MySQL 8.0.16 for the database. Click “Continue”. MySQL 8.0.16 will download and Local will try to start your site.

If that works, let us know — it at least gives you a workaround for now.

If it doesn’t work, please could you share your logs again after the site fails to start?

Thanks for your patience and perseverance with this. I’m interested to see what’s causing sites to fail to start for you.

Hi, same issue. I contacted support team, got a response that local support team will assist

Hi @offbeat

Have you tried any troubleshooting steps so far?

Could you provide some more details to help us take a further look?

  • What is your OS?

  • What version of Local are you on?

  • Please attach a copy of your Local Logs

Keep us posted and we’d be happy to help further!

Hi @Nick-B

Windows. I downloaded 9.2.2. Got error, can’t connect to MySQL server. Uninstalled and reinstalled. Downloaded 9.2.0. Created Custom site instead of Preferred.
local-lightning.log (140.8 KB)

@Nick-B log in chat is okay? If you want email address, let me know.

any update?

@offbeat

Can you try the steps outlined here to see if using MySQL v8.0.16 works?

@Nick-B

I had already done steps by changing to Custom. I installed MAMP. There was message so i deleted Local but still getting some error. I am stuck

You’re still getting the same error in MAMP as well?

Have you reinstalled Local? Once you’ve tried in Local again could you share a fresh Local log here? Retrieving Local’s Log File

okay, will reinstall

Keep us posted @offbeat and we’d be happy to help further!