/usr/sbin/mysqld: unknown variable 'innodb=OFF'

Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.

之后查看状态
ysqld.service - LSB: start and stop MySQL
Loaded: loaded (/etc/init.d/mysqld; bad; vendor preset: enabled)
Active: failed (Result: exit-code) since 三 2019-06-12 10:50:55 CST; 9s ago
Docs: man:systemd-sysv-generator(8)
Process: 3376 ExecStart=/etc/init.d/mysqld start (code=exited, status=1/FAILURE)

6月 12 10:50:54 Kylin mysqld[3560]: 190612 10:50:54 [ERROR] /usr/sbin/mysqld: unknown variable 'innodb=OFF'
6月 12 10:50:54 Kylin mysqld[3560]: 190612 10:50:54 [ERROR] Aborting
6月 12 10:50:54 Kylin mysqld[3560]:
6月 12 10:50:54 Kylin mysqld[3560]: 190612 10:50:54 [Note] /usr/sbin/mysqld: Shutdown complete
6月 12 10:50:54 Kylin mysqld[3560]:
6月 12 10:50:55 Kylin mysqld[3376]: . * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
6月 12 10:50:55 Kylin systemd[1]: mysqld.service: Control process exited, code=exited status=1
6月 12 10:50:55 Kylin systemd[1]: Failed to start LSB: start and stop MySQL.
6月 12 10:50:55 Kylin systemd[1]: mysqld.service: Unit entered failed state.
6月 12 10:50:55 Kylin systemd[1]: mysqld.service: Failed with result 'exit-code'.                    求大神的解决方法。

编辑 /etc/my.cnf 文件，把 innodb=OFF 这行注释掉

admin 发表于 2019-6-12 14:11
编辑 /etc/my.cnf 文件，把 innodb=OFF 这行注释掉

我把my.cnf文件还原了。一直是报的这个错

● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/init.d/mysqld; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since 三 2019-06-12 14:15:41 CST; 6s ago
     Docs: man:systemd-sysv-generator(8)
  Process: 6168 ExecStart=/etc/init.d/mysqld start (code=exited, status=1/FAILURE)

6月 12 14:15:40 Kylin mysqld[6337]: 190612 14:15:40 [ERROR] Unknown/unsupported storage engine: InnoDB
6月 12 14:15:40 Kylin mysqld[6337]: 190612 14:15:40 [ERROR] Aborting
6月 12 14:15:40 Kylin mysqld[6337]:
6月 12 14:15:40 Kylin mysqld[6337]: 190612 14:15:40 [Note] /usr/sbin/mysqld: Shutdown complete
6月 12 14:15:40 Kylin mysqld[6337]:
6月 12 14:15:41 Kylin mysqld[6168]: . * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
6月 12 14:15:41 Kylin systemd[1]: mysqld.service: Control process exited, code=exited status=1
6月 12 14:15:41 Kylin systemd[1]: Failed to start LSB: start and stop MySQL.
6月 12 14:15:41 Kylin systemd[1]: mysqld.service: Unit entered failed state.
6月 12 14:15:41 Kylin systemd[1]: mysqld.service: Failed with result 'exit-code'.

mr_lu 发表于 2019-6-12 14:16
我把my.cnf文件还原了。一直是报的这个错

● mysqld.service - LSB: start and stop MySQL

编辑my.cnf文件，在[mysqld]下面添加一行：
default-storage-engine=INNODB

admin 发表于 2019-6-12 14:22
编辑my.cnf文件，在[mysqld]下面添加一行：
default-storage-engine=INNODB

添加了，换错了
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/init.d/mysqld; bad; vendor preset: enabled)
   Active: failed (Result: exit-code) since 三 2019-06-12 14:23:17 CST; 4s ago
   Docs: man:systemd-sysv-generator(8)
   Process: 6610 ExecStart=/etc/init.d/mysqld start (code=exited, status=1/FAILURE)

6月 12 14:23:16 Kylin mysqld[6782]: 190612 14:23:16 [Note] Plugin 'FEEDBACK' is disabled.
6月 12 14:23:16 Kylin mysqld[6782]: 190612 14:23:16 [ERROR] Can't open the mysql.plugin table. Please run mysql_upgrade to create it.
6月 12 14:23:16 Kylin mysqld[6782]: 190612 14:23:16 [ERROR] Can't open and lock privilege tables: Unknown storage engine 'InnoDB'
6月 12 14:23:16 Kylin mysqld[6782]: 190612 14:23:16 [Note] Server socket created on IP: '127.0.0.1'.
6月 12 14:23:16 Kylin mysqld[6782]: 190612 14:23:16 [ERROR] Fatal error: mysql.user table is damaged or in unsupported 3.20 format.
6月 12 14:23:17 Kylin mysqld[6610]: . * The server quit without updating PID file (/var/run/mysqld/mysqld.pid).
6月 12 14:23:17 Kylin systemd[1]: mysqld.service: Control process exited, code=exited status=1
6月 12 14:23:17 Kylin systemd[1]: Failed to start LSB: start and stop MySQL.
6月 12 14:23:17 Kylin systemd[1]: mysqld.service: Unit entered failed state.
6月 12 14:23:17 Kylin systemd[1]: mysqld.service: Failed with result 'exit-code'.

mr_lu 发表于 2019-6-12 14:24
添加了，换错了
● mysqld.service - LSB: start and stop MySQL
   Loaded: loaded (/etc/init.d/mysqld ...

你按照下面这个链接安装Mysql吧，你这编译安装太多报错了，不知道要排错到什么时候
https://www.51anidea.com/forum.p ... &extra=page%3D1

admin 发表于 2019-6-12 14:31
你按照下面这个链接安装Mysql吧，你这编译安装太多报错了，不知道要排错到什么时候
https://www.51anidea ...

重新安装一遍不会有问题吗?用把之前的卸载吗？

mr_lu 发表于 2019-6-12 14:32
重新安装一遍不会有问题吗?用把之前的卸载吗？

你之前编译安装的吗 编译安装的话，把安装目录删掉就行了

admin 发表于 2019-6-12 14:31
你按照下面这个链接安装Mysql吧，你这编译安装太多报错了，不知道要排错到什么时候
https://www.51anidea ...

我的系统是ubuntu的，没办法联网。而且编译安装的应该是没问题的啊

mr_lu 发表于 2019-6-12 14:34
我的系统是ubuntu的，没办法联网。而且编译安装的应该是没问题的啊

ubuntu编译安装mysql的方法：
https://www.51anidea.com/forum.p ... &extra=page%3D1