mysql 启动失败：su: warning: cannot change directory to /nonexistent: No such file or directory

使用 Docker 部署的 MySQL 启动失败

报错：su: warning: cannot change directory to /nonexistent: No such file or directory

这种错误一般是 mysql 服务器异常关机导致的^[2]，解决方案如下：

sudo service mysql stop
sudo usermod -d /var/lib/mysql/ mysql
sudo service mysql start

sudo systemctl stop mysql.service
sudo usermod -d /var/lib/mysql/ mysql
sudo systemctl start mysql.service

docker 以上两种都试一下

docker 可能存在“启动时不报错但是卡住”的情况，docker restart一下可能会解决问题。

[1] 参考https://stackoverflow.com/questions/62987154/mysql-wont-start-error-su-warning-cannot-change-directory-to-nonexistent
[2] 参考https://www.cnblogs.com/shiningrise/p/17474741.html