MySQL Bugs: #104442: mysqld doesn't work with Windows Sandbox on Windows 10

Bug #104442	mysqld doesn't work with Windows Sandbox on Windows 10
Submitted:	28 Jul 2021 15:03	Modified:	29 Jul 2021 9:19
Reporter:	Yu Liu	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Windows	Severity:	S3 (Non-critical)
Version:	5.7	OS:	Windows (Windows 10)
Assigned to:		CPU Architecture:	Any

Description:
I'm on Windows 10 Pro 21H1 with July 2021 update.
The mysql server is mysql-5.7.34-winx64 which is extracted from the downloaded zip file.

mysqld used to work fine on my PC but after I've enabled Windows Sandbox from the control panel, it fails to start.

mysqld will have the following logs and shutdowns itself:

2021-07-28T14:40:54.323665Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2021-07-28T14:40:54.325492Z 0 [Note] IPv6 is available.
2021-07-28T14:40:54.325809Z 0 [Note]   - '::' resolves to '::';
2021-07-28T14:40:54.326133Z 0 [Note] Server socket created on IP: '::'.
2021-07-28T14:40:54.326467Z 0 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2021-07-28T14:40:54.326873Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2021-07-28T14:40:54.327294Z 0 [ERROR] Aborting

I'm pretty sure no app was using port 3306 and changing mysqld's bind port won't do anything different.

I found a similar report on Stackoverflow https://stackoverflow.com/a/63483521/6681141 so I followed it to disable Windows Sandbox and mysqld could get started.

How to repeat:
On Windows 10, enable Windows Sandbox.

Suggested fix:
Disable Windows Sandbox.

MySQL 5.7.35 running on Windows 10 Pro SandBox

Attachment: 104442.png (image/png, text), 155.05 KiB.

We're sorry, but the bug system is not the appropriate forum for asking help on using MySQL products. Your problem is not the result of a bug.

For details on getting support for MySQL products see http://www.mysql.com/support/
You can also check our forums (free) at http://forums.mysql.com/

Thank you for your interest in MySQL.

Oh, I'm really sorry I didn't make this report clear and I didn't use the latest version of mysql-server on Windows.

The issue I wanted to report was that with Windows Sandbox enabled, mysqld (ver. <=5.7.34) will not start on the host machine and the logged error message is showed as previously reported.

And.. I just realized that 5.7.35 is the latest version by now and with this version mysqld can get started while Windows Sandbox is enabled at the same time.

I'm so sorry for not using the latest version. And I'm quite astonished by how MySQL's download archives are handled, where the latest version of each distribution is not included in archives.

So this report may be tagged as closed since the issue does exist but with a newer version of mysql it's gone.

Wait a minute.. The server can't start again.

Thank you for the feedback. Now I was able to repeat not able to start a standalone 5.7 server, uninstalling Sandbox the start works.