WSL中MySQL-server安装失败及报错问题求助

问题现象 #

在Windows Subsystem for Linux（WSL）中安装MySQL-server时，反复出现以下报错：

* Stopping MySQL database server mysqld                         [ OK ]
Renaming removed key_buffer and myisam-recover options (if present)
Cannot open /proc/net/unix: No such file or directory
Cannot stat file /proc/1/fd/4: Operation not permitted
Cannot stat file /proc/1/fd/7: Operation not permitted
Cannot stat file /proc/4/fd/4: Operation not permitted
Cannot stat file /proc/919/fd/8: Operation not permitted
Cannot stat file /proc/919/fd/4: Operation not permitted
mysqld will log errors to /var/log/mysql/error.log
mysqld is running as pid 3044
dpkg: error processing package mysql-server-8.0 (--configure):
 installed mysql-server-8.0 package post-installation script subprocess returned error exit status 1

以及依赖错误：

dpkg: dependency problems prevent configuration of mysql-server:
 mysql-server depends on mysql-server-8.0; however:
  Package mysql-server-8.0 is not configured yet.

dpkg: error processing package mysql-server (--configure):
 dependency problems - leaving unconfigured
Setting up software-properties-common (0.99.22.6) ...
No apport report written because the error message indicates its a followup error from a previous failure.
                                  Processing triggers for man-db (2.10.2-1) ...
Processing triggers for dbus (1.12.20-2ubuntu4) ...
Errors were encountered while processing:
 mysql-server-8.0
 mysql-server
needrestart is being skipped since dpkg has failed
E: Sub-process /usr/bin/dpkg returned an error code (1)

常规的apt-get install强制安装、--fix-broken修复、dpkg配置清理均无效。

解决步骤 #

1. 确认并切换到WSL2（关键） #

WSL1对/proc文件系统支持有限，是导致这类报错的核心原因：

• 打开Windows PowerShell，运行以下命令查看当前WSL版本：

  wsl --list --verbose
  

• 若你的发行版处于WSL1模式，运行以下命令切换到WSL2（替换<发行版名称>为实际名称，如Ubuntu-20.04）：

  wsl --set-version <发行版名称> 2
  

2. 彻底清理MySQL残留文件 #

残留的配置文件或进程会干扰重新安装，执行以下命令完全卸载并清理：

# 终止所有MySQL进程
sudo killall mysqld

# 卸载所有MySQL相关包
sudo apt-get purge mysql-server mysql-server-8.0 mysql-client mysql-common mysql-server-core-8.0 mysql-client-core-8.0

# 清理无用依赖和缓存
sudo apt-get autoremove
sudo apt-get autoclean

# 删除MySQL数据、配置、日志目录
sudo rm -rf /var/lib/mysql/
sudo rm -rf /etc/mysql/
sudo rm -rf /var/log/mysql/

# 修复dpkg状态
sudo dpkg --configure -a
sudo apt-get update

3. 重新安装MySQL并手动初始化 #

WSL默认未启用systemd，MySQL的post-install脚本依赖systemd会导致配置失败，需手动完成后续步骤：

1. 重新安装MySQL-server：

   sudo apt-get install mysql-server
   

2. 手动启动MySQL服务：

   sudo service mysql start
   

3. 执行安全配置向导：

   sudo mysql_secure_installation
   

4. 可选：启用WSL2的systemd支持（如需用systemctl管理） #

若需要通过systemctl命令管理MySQL，可启用WSL2的systemd：

1. 编辑WSL配置文件：

   sudo nano /etc/wsl.conf
   

2. 添加以下内容并保存：

   [boot]
   systemd=true
   

3. 在Windows PowerShell中关闭WSL会话，重新启动：

   wsl --shutdown
   

4. 重新进入WSL后，启动MySQL服务：

   sudo systemctl start mysql
   

内容的提问来源于stack exchange，提问作者Opeoluwa-Muritala