mysql启动碰到错误 Can't find error-message file '/usr/local/mysql/share/errmsg.sys'.

碰到这个错误的原因是因为在my.cnf文件中没有指定language参数
language = /scratch/mysql-5.7.25-linux-glibc2.12-x86_64/share/english

[root@rws1270173 bin]# ./mysqld start
2019-06-05T01:52:28.940460Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-06-05T01:52:28.940539Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-06-05T01:52:28.940567Z 0 [Note] ./mysqld (mysqld 5.7.25-log) starting as process 55184 ...
2019-06-05T01:52:28.940599Z 0 [ERROR] Can't find error-message file '/usr/local/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
2019-06-05T01:52:28.943391Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2019-06-05T01:52:28.943473Z 0 [ERROR] Aborting

2019-06-05T01:52:28.943503Z 0 [Note] Binlog end
2019-06-05T01:52:28.943662Z 0 [Note]


出现错误[ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!的原因shi因为使用了root启动mysql
需要加一个参数以mysql用户启动
./mysqld start -u mysql 

[root@rws1270173 bin]# ./mysqld start
2019-06-05T01:59:53.615029Z 0 [Warning] The syntax '--language/-l' is deprecated and will be removed in a future release. Please use '--lc-messages-dir' instead.
2019-06-05T01:59:53.615091Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2019-06-05T01:59:53.615134Z 0 [Note] --secure-file-priv is set to NULL. Operations related to importing and exporting data are disabled
2019-06-05T01:59:53.615159Z 0 [Note] ./mysqld (mysqld 5.7.25-log) starting as process 59976 ...
2019-06-05T01:59:53.617157Z 0 [Warning] Using pre 5.5 semantics to load error messages from /scratch/mysql-5.7.25-linux-glibc2.12-x86_64/share/english/.
2019-06-05T01:59:53.617166Z 0 [Warning] If this is not intended, refer to the documentation for valid usage of --lc-messages-dir and --language parameters.
2019-06-05T01:59:53.618213Z 0 [ERROR] Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root!

2019-06-05T01:59:53.618288Z 0 [ERROR] Aborting

2019-06-05T01:59:53.618310Z 0 [Note] Binlog end
2019-06-05T01:59:53.618498Z 0 [Note] ./mysqld: Shutdown complete



在启动时候碰到下面的错误，原因是因为没有--apply-log
这是因为使用extrabackup恢复数据库后，没有运行--apply-log那一步

2019-06-05T02:02:34.842543Z 0 [ERROR] InnoDB: Page [page id: space=13, page number=3] log sequence number 1347543709 is in the future! Current system log sequence number 1347510595.
2019-06-05T02:02:34.842576Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.
2019-06-05T02:02:34.842713Z 0 [ERROR] InnoDB: Page [page id: space=14, page number=3] log sequence number 1347544890 is in the future! Current system log sequence number 1347510595.
2019-06-05T02:02:34.842741Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.
2019-06-05T02:02:34.843179Z 0 [ERROR] InnoDB: Page [page id: space=18, page number=3] log sequence number 1347538212 is in the future! Current system log sequence number 1347510595.
2019-06-05T02:02:34.843205Z 0 [ERROR] InnoDB: Your database may be corrupt or you may have copied the InnoDB tablespace but not the InnoDB log files. Please refer to http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html for information about forcing recovery.
2019-06-05T02:02:34.844496Z 0 [Note] InnoDB: Buffer pool(s) load completed at 190604 19:02:34
2019-06-05T02:02:34.846427Z 0 [ERROR] Can't open shared library '/usr/local/mysql/lib/plugin/semisync_master.so' (errno: 2 /usr/local/mysql/lib/plugin/semisync_master.so: cannot open shared object file: No such file or directory)
2019-06-05T02:02:34.846449Z 0 [Warning] Couldn't load plugin named 'rpl_semi_sync_master' with soname 'semisync_master.so'.
2019-06-05T02:02:34.846496Z 0 [ERROR] Can't open shared library '/usr/local/mysql/lib/plugin/semisync_slave.so' (errno: 2 /usr/local/mysql/lib/plugin/semisync_slave.so: cannot open shared object file: No such file or directory)
2019-06-05T02:02:34.846512Z 0 [Warning] Couldn't load plugin named 'rpl_semi_sync_slave' with soname 'semisync_slave.so'.
2019-06-05T02:02:34.846662Z 0 [ERROR] unknown variable 'rpl_semi_sync_master_enabled=1'
2019-06-05T02:02:34.846682Z 0 [ERROR] Aborting