WSL2 安装 2233466866/lnmp:newest ，mysql 启动失败如何解决?

[overlordz]

[root@79ae4d783f8a mysql]# systemctl status mysqld
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: deactivating (stop-sigterm) (Result: exit-code)
  Process: 2896 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=1/FAILURE)
  Process: 2872 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
   CGroup: /docker/79ae4d783f8aa83a791c2b30d96fa721867dece0a06bd1ce56fc23306a5c8950/system.slice/mysqld.service
           └─2898 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Mar 23 22:05:30 79ae4d783f8a systemd[1]: Starting MySQL Server...
Mar 23 22:05:30 79ae4d783f8a mysqld_pre_systemd[2872]: 2022-03-23T14:05:30.936946Z 0 [Warning] Ignoring user change to 'mysql' because the user was set to 'www' earlier on the command line
Mar 23 22:05:30 79ae4d783f8a mysqld_pre_systemd[2872]: 2022-03-23T14:05:30.936990Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp ...ore details).
Mar 23 22:05:30 79ae4d783f8a mysqld_pre_systemd[2872]: 2022-03-23T14:05:30.938849Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
Mar 23 22:05:30 79ae4d783f8a mysqld_pre_systemd[2872]: 2022-03-23T14:05:30.938880Z 0 [ERROR] Aborting
Mar 23 22:05:31 79ae4d783f8a systemd[1]: mysqld.service: control process exited, code=exited status=1
Hint: Some lines were ellipsized, use -l to show in full.

执行 [root@spark01 ~]# journalctl -xe

-- The result is failed.
Mar 23 22:09:57 79ae4d783f8a systemd[1]: Unit mysqld.service entered failed state.
Mar 23 22:09:57 79ae4d783f8a systemd[1]: mysqld.service failed.
Mar 23 22:09:57 79ae4d783f8a systemd[1]: mysqld.service holdoff time over, scheduling restart.
Mar 23 22:09:57 79ae4d783f8a systemd[1]: Stopped MySQL Server.
-- Subject: Unit mysqld.service has finished shutting down
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has finished shutting down.
Mar 23 22:09:57 79ae4d783f8a systemd[1]: Starting MySQL Server...
-- Subject: Unit mysqld.service has begun start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit mysqld.service has begun starting up.
Mar 23 22:09:57 79ae4d783f8a mysqld_pre_systemd[7917]: 2022-03-23T14:09:57.437478Z 0 [Warning] Ignoring user change to 'mysql' because the user was set to 'www' earlier on the command line
Mar 23 22:09:57 79ae4d783f8a mysqld_pre_systemd[7917]: 2022-03-23T14:09:57.437520Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (s
Mar 23 22:09:57 79ae4d783f8a mysqld_pre_systemd[7917]: 2022-03-23T14:09:57.439410Z 0 [ERROR] --initialize specified but the data directory has files in it. Aborting.
Mar 23 22:09:57 79ae4d783f8a mysqld_pre_systemd[7917]: 2022-03-23T14:09:57.439443Z 0 [ERROR] Aborting
Mar 23 22:09:58 79ae4d783f8a mysqld[7941]: Initialization of mysqld failed: 0
Mar 23 22:09:58 79ae4d783f8a systemd[1]: mysqld.service: control process exited, code=exited status=1
Mar 23 22:09:59 79ae4d783f8a systemd[1]: Failed to start MySQL Server.

文件目录权限

drwxrwxrwx 1 www www 4096 Mar 23  2022 mysql
[root@79ae4d783f8a data]# cd mysql/
[root@79ae4d783f8a mysql]# ll
total 122884
-rwxrwxrwx 1 www www       56 Mar 23 22:14 auto.cnf
-rwxrwxrwx 1 www www     1680 Mar 23 22:14 ca-key.pem
-rwxrwxrwx 1 www www      281 Mar 23 22:14 ib_buffer_pool
-rwxrwxrwx 1 www www 12582912 Mar 23  2022 ibdata1
-rwxrwxrwx 1 www www 50331648 Mar 23  2022 ib_logfile0
-rwxrwxrwx 1 www www 50331648 Mar 19 16:04 ib_logfile1
-rwxrwxrwx 1 www www 12582912 Mar 23 22:14 ibtmp1

[overlordz]

解决了，分享一下过程： 1、清除mysql 下的所有文件 2、/var/log/mysqld.log 赋予权限

[2233466866]

解决了，分享一下过程： 1、清除mysql 下的所有文件 2、/var/log/mysqld.log 赋予权限

感谢科普。