mysqld.log里的一个错误

Question

这边启动mysql的时候启动不了，报了一个这样的错：Job for mysqld.service failed because the control process exited with error code. See “systemctl status mysqld.service” and “journalctl -xe” for details。然后查了下mysql的日志。也就是cat /var/log/mysqld.log，看到是有如下的错：
2019-06-18T08:17:25.891663Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-06-18T08:17:25.994776Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2019-06-18T08:17:25.994807Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2019-06-18T08:17:26.697893Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2019-06-18T08:17:26.698203Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-06-18T08:17:26.698324Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-06-18T08:17:26.745756Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16) MySQL Community Server - GPL.
那么这个是应该怎么操作呢？已经忘了安装那会遇到的细节情况了。烦请老师来指点一二呀。

Answer 1

编程浪子 2019-06-21 09:33:12

你好

不好意思，消息淹没了

你安装的数据库是什么版本了？ 

• 提问者 szuxxy #1

  版本是8开头的最新的。
  后来我 执行了一个这个命令：
  [root@VM_0_6_centos lib]# sudo /usr/sbin/mysqld start
  2019-06-20T14:01:20.790937Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.16) starting as process 3964
  2019-06-20T14:01:20.792790Z 0 [ERROR] [MY-010123] [Server] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!
  然后查了下这个的解决方法。
  接着vim /etc/my.cnf
  就这样了：

• 提问者 szuxxy #2

  E325: ATTENTION
  Found a swap file by the name "/etc/.my.cnf.swp"
            owned by: root   dated: Thu Jun 20 22:30:59 2019
           file name: /etc/my.cnf
            modified: YES
           user name: root   host name: VM_0_6_centos
          process ID: 6516
  While opening file "/etc/my.cnf"
               dated: Thu Jun 20 22:40:58 2019
        NEWER than swap file!
  
  (1) Another program may be editing the same file.  If this is the case,
      be careful not to end up with two different instances of the same
      file when making changes.  Quit, or continue with caution.
  (2) An edit session for this file crashed.
      If this is the case, use ":recover" or "vim -r /etc/my.cnf"
      to recover the changes (see ":help recovery").
      If you did this already, delete the swap file "/etc/.my.cnf.swp"
      to avoid this message.
  
  Swap file "/etc/.my.cnf.swp" already exists!
  [O]pen Read-Only, (E)dit anyway, (R)ecover, (D)elete it, (Q)uit, (A)bort:* Connection closed *

• 提问者 szuxxy #3

  这边重置了下云服务器，然后按照我上面写的步骤操作了一遍就好了。谢谢。

Answer 2

提问者 szuxxy 2019-06-23 22:04:04

老师，这边重新装了下这个5.7版本的，步骤是这样的：

第一步，进入到tmp目录里

cd /tmp

第二步，下载rpm

wget https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

第三步，localinstall

yum localinstall mysql57-community-release-el7-11.noarch.rpm

第四步，search 一下

yum search mysql

第五步，yum install mysql-community-server

但是看password是没有的：cat /var/log/mysqld.log |grep password

过滤failed倒是有一大堆：

[root@VM_0_6_centos ~]# cat /var/log/mysqld.log |grep failed

2019-06-08T13:57:23.596239Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-08T14:08:35.524789Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-08T14:15:41.496839Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-08T14:34:49.785997Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-08T14:43:48.408402Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-08T14:45:55.898563Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T07:40:42.956415Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T10:00:53.170863Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T10:05:30.233564Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T10:06:08.506670Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T10:06:16.124171Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-15T10:31:45.331263Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-18T08:17:26.698203Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-20T13:28:01.201357Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-20T13:37:36.056175Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-20T13:57:38.960748Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-22T13:13:12.631269Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-22T14:51:35.135061Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

2019-06-22T15:01:29.253082Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.

开启服务没有报错，（以前是有报错的）但是：

[root@VM_0_6_centos ~]# service mysqld start

Redirecting to /bin/systemctl start mysqld.service

[root@VM_0_6_centos ~]# 

so...

Answer 3

编程浪子 2019-06-21 11:28:14

你好

swp文件是有其他地方打开没有正常关闭影响的。可以直接删除

rm /etc/.my.cnf.swp

还有建议按照5.7版本，5.8 属于大版本还有有很多和5.7 不一样的

5.7的yum源

https://dev.mysql.com/get/mysql57-community-release-el7-11.noarch.rpm

我们在学习一个东西尽量和课程一样，等课程学完了在学习新的不同的东西，软件肯定会一直都有更新的

Answer 4

编程浪子 2019-06-18 18:35:50

你好

你安装的数据库是什么版本了？

• 提问者 szuxxy #1

  [root@VM_0_6_centos ~]# mysql
  ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
  [root@VM_0_6_centos ~]# ps -ef |grep mysql
  root      2103  1930  0 18:44 pts/0    00:00:00 grep --color=auto mysql
  这是说装失败了么？这进程...

• 提问者 szuxxy #2

  老师，你肿么不理我了？

• 提问者 szuxxy #3

  版本是8.

Answer 5

提问者 szuxxy 2019-06-18 16:30:43

记录启动在centos下启动mysql失败
0.查看mysql是否安装成功
[root@VM_0_6_centos ~]# whereis mysql
mysql: /usr/bin/mysql /usr/lib64/mysql /usr/share/man/man1/mysql.1.gz
1.用命令启动mysql服务
[root@VM_0_6_centos ~]# service mysqld start
Redirecting to /bin/systemctl start mysqld.service
Job for mysqld.service failed because the control process exited with error code. See "systemctl status mysqld.service" and "journalctl -xe" for details.
2.使用命令systemctl status mysqld.service查看
[root@VM_0_6_centos ~]# 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 2019-06-15 18:06:16 CST; 6min ago
Docs: man:mysqld(8)
http://dev.mysql.com/doc/refman/en/using-systemd.html
Process: 1804 ExecStart=/usr/sbin/mysqld $MYSQLD_OPTS (code=exited, status=1/FAILURE)
Process: 1781 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
Main PID: 1804 (code=exited, status=1/FAILURE)
Status: "SERVER_BOOTING"
Error: 2 (No such file or directory)
Jun 15 18:06:15 VM_0_6_centos systemd[1]: Starting MySQL Server...
Jun 15 18:06:16 VM_0_6_centos systemd[1]: mysqld.service: main process exited, code=exited, status=1/FAILURE
Jun 15 18:06:16 VM_0_6_centos systemd[1]: Failed to start MySQL Server.
Jun 15 18:06:16 VM_0_6_centos systemd[1]: Unit mysqld.service entered failed state.
Jun 15 18:06:16 VM_0_6_centos systemd[1]: mysqld.service failed.
3.使用journalctl -xe命令查看
[root@VM_0_6_centos ~]# journalctl -xe
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit session-17458.scope has finished starting up.
--
-- The start-up result is done.
Jun 15 18:13:01 VM_0_6_centos CROND[2392]: (root) CMD (/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &)
Jun 15 18:13:38 VM_0_6_centos sshd[2445]: Invalid user backup from 62.234.135.67 port 32948
Jun 15 18:13:38 VM_0_6_centos sshd[2445]: input_userauth_request: invalid user backup [preauth]
Jun 15 18:13:38 VM_0_6_centos sshd[2445]: pam_unix(sshd:auth): check pass; user unknown
Jun 15 18:13:38 VM_0_6_centos sshd[2445]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=62.234.135.67
Jun 15 18:13:40 VM_0_6_centos sshd[2445]: Failed password for invalid user backup from 62.234.135.67 port 32948 ssh2
Jun 15 18:13:40 VM_0_6_centos sshd[2445]: Received disconnect from 62.234.135.67 port 32948:11: Bye Bye [preauth]
Jun 15 18:13:40 VM_0_6_centos sshd[2445]: Disconnected from 62.234.135.67 port 32948 [preauth]
Jun 15 18:14:01 VM_0_6_centos systemd[1]: Started Session 17459 of user root.
-- Subject: Unit session-17459.scope has finished start-up
-- Defined-By: systemd
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel
--
-- Unit session-17459.scope has finished starting up.
--
-- The start-up result is done.
Jun 15 18:14:01 VM_0_6_centos CROND[2471]: (root) CMD (/usr/local/qcloud/stargate/admin/start.sh > /dev/null 2>&1 &)
Jun 15 18:14:35 VM_0_6_centos sshd[2525]: Invalid user zhou from 62.234.135.67 port 46716
Jun 15 18:14:35 VM_0_6_centos sshd[2525]: input_userauth_request: invalid user zhou [preauth]
Jun 15 18:14:35 VM_0_6_centos sshd[2525]: pam_unix(sshd:auth): check pass; user unknown
Jun 15 18:14:35 VM_0_6_centos sshd[2525]: pam_unix(sshd:auth): authentication failure; logname= uid=0 euid=0 tty=ssh ruser= rhost=62.234.135.67
Jun 15 18:14:37 VM_0_6_centos sshd[2525]: Failed password for invalid user zhou from 62.234.135.67 port 46716 ssh2
Jun 15 18:14:37 VM_0_6_centos sshd[2525]: Received disconnect from 62.234.135.67 port 46716:11: Bye Bye [preauth]
Jun 15 18:14:37 VM_0_6_centos sshd[2525]: Disconnected from 62.234.135.67 port 46716 [preauth]
到mysql的日志里看一下：
[root@VM_0_6_centos ~]# cat /var/log/mysqld.log
#618重要的信息
2019-06-18T08:17:25.891663Z 1 [System] [MY-011012] [Server] Starting upgrade of data directory.
2019-06-18T08:17:25.994776Z 1 [ERROR] [MY-013090] [InnoDB] Unsupported redo log format (0). The redo log was created before MySQL 5.7.9
2019-06-18T08:17:25.994807Z 1 [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error.
2019-06-18T08:17:26.697893Z 1 [ERROR] [MY-011013] [Server] Failed to initialize DD Storage Engine.
2019-06-18T08:17:26.698203Z 0 [ERROR] [MY-010020] [Server] Data Dictionary initialization failed.
2019-06-18T08:17:26.698324Z 0 [ERROR] [MY-010119] [Server] Aborting
2019-06-18T08:17:26.745756Z 0 [System] [MY-010910] [Server] /usr/sbin/mysqld: Shutdown complete (mysqld 8.0.16)  MySQL Community Server - GPL.