I have below error when create new site.
Environment
Windows 10(64bit)
Run Local with Administrator
Site Name: Test
User name: dev
User pass: dev
User email: test@test.com
I attached log file
local-lightning-verbose0.log (172.1 KB)
error.log (8.1 KB)
local-details.json (993 Bytes)
Please let me know asap how can I fix it.
Thank you.
Hi @ioborin
We have a Windows Troubleshooting guide below that goes over some common items worth checking. For example, make sure you’re running Local as an admin user, that you don’t have any security blockers, and that Local has access to update your Hosts file.
I followed troubleshooting guide but can’t fix isse.
Disabled all security blockers, host file and run with administrator
I removed your login credentials since we can’t use those to access.
Can you try changing your Router Mode and see if that makes a difference? What is Router Mode? - Local
I changed Router Mode into Localhost but can’t create site.
Does your username/password contain any special characters or spaces?
No. It is kingmpo / kingmpo
Can you share a fresh log here? There are some different ways to access and share Local Logs. For us to be able to troubleshoot thoroughly, please click the Download Local Logs button from the Support tab in Local. This will generate a zip archive that contains the Local log along with some other diagnostic information to help quickly zero in on any issues that Local is encountering.
local-logs.zip (26.5 KB)
Sent Log files
@Nick-B Is there any update?
Hi @ioborin - I had a chance to look at your logs. Here is the exact error in question…
{“level”:“error”,“message”:“Error setting up MySQL user”,“service”:“mysql”,“serviceBinVersion”:“8.0.35”,“stack”:“Error: Command failed: %%userDataPath%%\lightning-services\mysql-8.0.35+2\bin\win64\bin\mysql.exe --password= -e ALTER USER ‘root’@‘localhost’ IDENTIFIED WITH mysql_native_password BY ‘root’;\nmysql: [Warning] Using a password on the command line interface can be insecure.\r\nERROR 2003 (HY000): Can’t connect to MySQL server on ‘::1:10005’ (10013)\r\n\n at genericNodeError (node:internal/errors:983:15)\n at wrappedFn (node:internal/errors:537:14)\n at ChildProcess.exithandler (node:child_process:414:12)\n at ChildProcess.emit (node:events:518:28)\n at maybeClose (node:internal/child_process:1101:16)\n at ChildProcess._handle.onexit (node:internal/child_process:304:5)”,“thread”:“main”,“timestamp”:“2025-05-16T14:19:05.319Z”}
MySQL fails to install, which means the site creation will fail. Specifically, it is trying to grab port 10005 and is unable to do so, probably because something else is using it.
Can you check out Resource Manager (StackOverflow example linked) to see if you can identify what is using port 10005 and if able, kill that process and try again? I’m curious to know what the conflict here is as well.
