When creating a site it gives error 2003 (hy000): cant connect to mysql server on ::1:10005 (10013)
This is my first time using LocalWP, when creating a site I got this error
local-logs.zip (53.3 KB)
Hi @Korenevo!
It seems like there might be a port conflict preventing things from working here. You could try changing your Router Mode to see if that gets around it: What is Router Mode? - Local
Here is another article with some additional troubleshooting steps regarding narrowing down the conflict and addressing it:
Hello, I tried to do Router Mode on the local network, the same error, I read the first link, tried to do as it said, it did not help, and I followed the second link, there was a blank page
One thing you can try is opening the Windows Task Manager and killing any MySQL entries that appear. After that, you can try restarting the site.
Is there anything else unique about your device or network? Do you have full administrative control? We have a Windows Troubleshooting guide below that goes over some common items worth checking as well. For example, ensure that Local is running as an administrator, that there are no security blockers, and that Local has access to update the Hosts file.
I tried deleting tasks, but it didn’t help. I can’t even create a website; it keeps giving me this error. After clicking OK, the website is deleted.
Nothing special about PCs and networks. Windows 11 Pro, mostly through a VPN, but from what I read on this forum, it doesn’t make any difference. Running it as administrator makes no difference. The Hosts file didn’t initially have the “read-only” checkbox checked. Both the private and public checkboxes are checked in Firewall. I also tried disabling my antivirus, but that didn’t help.
After trying to start a site in Local if you open Task Manager do you see mysqld.exe running at all in there @Korenevo?
If it is running, then there could still be some sort of block happening on your network or device somewhere. If it’s not running at all then there could be another issue at play. So doing a full uninstall and reinstall might be the next step there. Uninstall Local - Local
It appears when I try to create a website, and when the error pops up, it disappears. I previously completely deleted it as instructed in the article, but I did it again now and nothing changed.
Okay it’s possible something has become corrupted or wasn’t installed properly. So it might be worth doing a full uninstall and reinstall. One last check would be to make sure your device has enough disk space to run the application. Does the storage still look good?
After checking that, you can follow the steps below:
-
Fully uninstall Local from your computer using the steps for your OS here: Uninstall Local - Local
-
Install the latest version of Local on this link: Releases - Local
-
Once installed, please restart the computer.
-
When the computer is restarted and turned on, close any applications that automatically run in the background (AntiVirus, Firewall, and other Developer applications included).
-
Check and see if the issue still persists. If so, please provide us with an updated log: Retrieve Local’s Log File - Local
I followed these steps, and it worked. Apparently, it’s a firewall issue; I’d previously only disabled my antivirus. How do I configure the firewall to make it work properly? As I mentioned earlier, I checked the boxes for both public and private networks for the Local and local.exe applications.
You should just need to select Firewall and Network protection, then “Allow an app to communicate through Windows Firewall” and select local.exe @Korenevo as far as Firewall settings go. Running the application as Administrator is also good.
Are you sure you don’t have any other security such as Bitdefender, Kaspersky, Avast or Avira?
Is this a personal device? Or one issued by an employer?
I found the reason why the site couldn’t be created; it had something to do with my mobile carrier. I disabled it while it was being created, and it created fine. I re-enabled it, and the site launched fine. For some reason, it’s the creation process with my mobile carrier that’s failing.
Your mobile hotspot might not have a strong enough connection to download the components Local reaches out for to set up your site. I’m glad that you narrowed it down to the network for now however and figured out a workaround!
Thank you for your help!