MySQL登录010119报错_MySQL无法启动，求解，在线等

2018-05-26T06:28:24.032571Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13143

2018-05-26T06:28:24.062933Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.

2018-05-26T06:28:24.062972Z 1 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.

2018-05-26T06:28:24.062980Z 1 [ERROR] [MY-012594] [InnoDB] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2018-05-26T06:28:24.062989Z 1 [ERROR] [MY-012646] [InnoDB] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation

2018-05-26T06:28:24.062999Z 1 [ERROR] [MY-012981] [InnoDB] InnoDB: Cannot continue operation.

2018-05-26T06:28:25.172069Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13178

2018-05-26T06:28:25.201941Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.

2018-05-26T06:28:25.201976Z 1 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.

2018-05-26T06:28:25.201985Z 1 [ERROR] [MY-012594] [InnoDB] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2018-05-26T06:28:25.201993Z 1 [ERROR] [MY-012646] [InnoDB] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation

2018-05-26T06:28:25.202002Z 1 [ERROR] [MY-012981] [InnoDB] InnoDB: Cannot continue operation.

2018-05-26T06:28:26.428896Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13214

2018-05-26T06:28:26.461862Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.

2018-05-26T06:28:26.461906Z 1 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.

2018-05-26T06:28:26.461914Z 1 [ERROR] [MY-012594] [InnoDB] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2018-05-26T06:28:26.461924Z 1 [ERROR] [MY-012646] [InnoDB] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation

2018-05-26T06:28:26.461933Z 1 [ERROR] [MY-012981] [InnoDB] InnoDB: Cannot continue operation.

2018-05-26T06:28:27.662607Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13248

2018-05-26T06:28:27.692006Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.

2018-05-26T06:28:27.692041Z 1 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.

2018-05-26T06:28:27.692048Z 1 [ERROR] [MY-012594] [InnoDB] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2018-05-26T06:28:27.692058Z 1 [ERROR] [MY-012646] [InnoDB] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation

2018-05-26T06:28:27.692067Z 1 [ERROR] [MY-012981] [InnoDB] InnoDB: Cannot continue operation.

2018-05-26T06:28:28.925266Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13284

2018-05-26T06:28:28.954619Z 1 [ERROR] [MY-012592] [InnoDB] InnoDB: Operating system error number 2 in a file operation.

2018-05-26T06:28:28.954652Z 1 [ERROR] [MY-012593] [InnoDB] InnoDB: The error means the system cannot find the path specified.

2018-05-26T06:28:28.954660Z 1 [ERROR] [MY-012594] [InnoDB] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.

2018-05-26T06:28:28.954676Z 1 [ERROR] [MY-012646] [InnoDB] InnoDB: File ./ibdata1: 'open' returned OS error 71. Cannot continue operation

2018-05-26T06:28:28.954685Z 1 [ERROR] [MY-012981] [InnoDB] InnoDB: Cannot continue operation.

2018-05-26T06:29:50.995170Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 13400

2018-05-26T06:29:53.138642Z 1 [ERROR] [MY-010781] [Server] Found ./mysql/index_stats.frm file in mysql schema. DD will create .ibd file with same name. Please rename table and start upgrade process again.

2018-05-26T06:29:53.138675Z 1 [ERROR] [MY-010336] [Server] Found .frm file with same name as one of the Dictionary Tables.

2018-05-26T06:29:53.138856Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2018-05-26T06:29:53.138886Z 0 [ERROR] [MY-010119] [Server] Aborting

2018-05-26T06:29:54.760802Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.

2018-05-26T06:29:54.760902Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure.

2018-05-26T07:18:31.679961Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.11) starting as process 15975

2018-05-26T07:18:32.081626Z 1 [ERROR] [MY-010781] [Server] Found ./mysql/index_stats.frm file in mysql schema. DD will create .ibd file with same name. Please rename table and start upgrade process again.

2018-05-26T07:18:32.081651Z 1 [ERROR] [MY-010336] [Server] Found .frm file with same name as one of the Dictionary Tables.

2018-05-26T07:18:32.081857Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2018-05-26T07:18:32.081887Z 0 [ERROR] [MY-010119] [Server] Aborting

2018-05-26T07:18:33.407529Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.11) MySQL Community Server - GPL.

2018-05-26T07:18:33.407655Z 0 [ERROR] [MY-010065] [Server] Failed to shutdown components infrastructure

systemctl status mysqld.service

● mysqld.service - MySQL Server

Loaded: loaded (/usr/lib/systemd/system/mysqld.service; bad; vendor preset: disabled)

Active: failed (Result: exit-code) since Sat 2018-05-26 15:18:33 CST; 5s ago

Docs: man:mysqld(8)

http://dev.mysql.com/doc/refman/en/using-systemd.html

Process: 15975 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)

Process: 15958 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)

Main PID: 15975 (code=exited, status=1/FAILURE)

Status: "SERVER_BOOTING"

Error: 2 (No such file or directory)

May 26 15:18:31 izuf65ov2pu9wezsqgtvbiz systemd[1]: Starting MySQL Server...

May 26 15:18:33 izuf65ov2pu9wezsqgtvbiz systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE

May 26 15:18:33 izuf65ov2pu9wezsqgtvbiz systemd[1]: Failed to start MySQL Server.

May 26 15:18:33 izuf65ov2pu9wezsqgtvbiz systemd[1]: Unit mysqld.service entered failed state.

May 26 15:18:33 izuf65ov2pu9wezsqgtvbiz systemd[1]: mysqld.service failed.

在线等，生产数据！！救济啊～