Bug #104442 mysqld doesn't work with Windows Sandbox on Windows 10
Submitted: 28 Jul 15:03 Modified: 29 Jul 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:Microsoft Windows (Windows 10)
Assigned to: CPU Architecture:Any

[28 Jul 15:03] Yu Liu
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.
[28 Jul 17:46] MySQL Verification Team
MySQL 5.7.35 running on Windows 10 Pro SandBox

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

[28 Jul 17:47] MySQL Verification Team
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.
[28 Jul 18:13] Yu Liu
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.
[28 Jul 18:21] Yu Liu
Wait a minute.. The server can't start again.
[29 Jul 9:19] MySQL Verification Team
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.