Nginx MySQL Database 5.7 system restart error

Objective

Life and Life Naijo???

Just go dry! Error:

650) this.width=650; "Src=" Https://s5.51cto.com/oss/201711/04/115708b9adec0281361505def74622e5.png-wh_500x0-wm_3 -wmp_4-s_2993537787.png "title=" 2017-11-04_143013.png "alt=" 115708b9adec0281361505def74622e5.png-wh_ "/>

Innodb:to Fix the problem and start mysqld:

INNODB:1) If There is a permission problem in the file and mysqld cannot

Innodb:open the file, you should modify the permissions.

INNODB:2) If The table is not needed, or can be restore it from a backup,

Innodb:then you can remove the. ibd file, and InnoDB would do a normal

Innodb:crash recovery and ignore that table.

Innodb:3) If the file system or the disk is broken, and you cannot remove

Innodb:the. ibd file, can set innodb_force_recovery > 0 in MY.CNF

Innodb:and force InnoDB to continue crash recovery here.

171104 14:50:28 mysqld_safe mysqld from PID File/var/run/mysqld/mysqld.pid ended

What's wrong with reading the newspaper?

Workaround: Modify/ETC/MY.CNF

In fact the error log has told us what to do: innodb:the. ibd file, you can set innodb_force_recovery > 0 in MY.CNF

This sentence means let's add a configuration setting for this innodb_force_recovery > 0, so I try to set it to 1 and then reboot successfully.

# The MySQL server

[Mysqld]

Innodb_force_recovery = 1/* Add one line and let it run independently, note that it must be under the MYSQLD option */

650) this.width=650; "Src=" Https://s1.51cto.com/oss/201711/04/e4256665e4cab368263b7b6ee95ed50c.png-wh_500x0-wm_3 -wmp_4-s_1397302967.png "title=" 2017-11-04_143038.png "alt=" E4256665e4cab368263b7b6ee95ed50c.png-wh_ "/>

Restart MSYQL systemctl Restart Mysqld

650) this.width=650; "Src=" Https://s3.51cto.com/oss/201711/04/124511e863b5a93e5664c986900aecd1.png-wh_500x0-wm_3 -wmp_4-s_1542701583.png "title=" 2017-11-04_144049.png "alt=" 124511e863b5a93e5664c986900aecd1.png-wh_ "/>

Login Successful!

650) this.width=650; "Src=" Https://s4.51cto.com/oss/201711/04/ffd4df31ed6aa0e16bdd7868391b374b.png-wh_500x0-wm_3 -wmp_4-s_2390234544.png "title=" 2017-11-04_144002.png "alt=" Ffd4df31ed6aa0e16bdd7868391b374b.png-wh_ "/>

Nginx error is as follows:

650) this.width=650; "Src=" Https://s3.51cto.com/oss/201711/04/f75a0b1d5cc4c86641e75b067fe65331.png-wh_500x0-wm_3 -wmp_4-s_2185514486.png "title=" 2017-11-04_144533.png "alt=" F75a0b1d5cc4c86641e75b067fe65331.png-wh_ "/>

Tail-10/var/log/nginx/error.log

2017/11/04 14:38:10 [Emerg] 12853#12853:module "/usr/lib64/nginx/modules/ngx_http_geoip_module.so" version 1010002 Instead of 1012001 in/usr/share/nginx/modules/mod-http-geoip.conf:1

2017/11/04 14:42:24 [Emerg] 13685#13685:module "/usr/lib64/nginx/modules/ngx_http_geoip_module.so" version 1010002 Instead of 1012001 in/usr/share/nginx/modules/mod-http-geoip.conf:1

2017/11/04 14:43:11 [Emerg] 13837#13837:module "/usr/lib64/nginx/modules/ngx_http_geoip_module.so" version 1010002 Instead of 1012001 in/usr/share/nginx/modules/mod-http-geoip.conf:1

2017/11/04 14:44:27 [Emerg] 14071#14071:module "/usr/lib64/nginx/modules/ngx_http_image_filter_module.so" version 1010002 instead of 1012001 in/usr/share/nginx/modules/mod-http-image-filter.conf:1

2017/11/04 14:46:12 [Emerg] 14400#14400:module "/usr/lib64/nginx/modules/ngx_http_geoip_module.so" version 1010002 Instead of 1012001 in/usr/share/nginx/modules/mod-http-geoip.conf:1

2017/11/04 14:46:20 [Emerg] 14434#14434:module "/usr/lib64/nginx/modules/ngx_http_geoip_module.so" version 1010002 Instead of 1012001 in/usr/share/nginx/modules/mod-http-geoip.conf:1

2017/11/04 15:03:28 [Emerg] 18276#18276: "Rewrite" directive is isn't allowed here in/etc/nginx/conf.d/newdefine.conf:1

2017/11/04 15:24:33 [Emerg] 21283#21283: "Rewrite" directive is isn't allowed here in/etc/nginx/conf.d/newdefine.conf:1

2017/11/04 15:34:29 [Emerg] 21390#21390: "Rewrite" directive is isn't allowed here in/etc/nginx/conf.d/newdefine.conf:1

2017/11/04 15:36:29 [Emerg] 21416#21416:unknown directive "Geoip_country" in/etc/nginx/conf.d/geoip.conf:1

Log analysis found that the configuration of conf is problematic!

650) this.width=650; "Src=" Https://s1.51cto.com/oss/201711/04/9a2713c3cea246b0fd2e22bcd799213d.png-wh_500x0-wm_3 -wmp_4-s_1518823606.png "title=" 2017-11-04_145339.png "alt=" 9a2713c3cea246b0fd2e22bcd799213d.png-wh_ "/>

Re-boot!

650) this.width=650; "Src=" Https://s1.51cto.com/oss/201711/04/74ad3364835b6ec7499abac2dc4c1e36.png-wh_500x0-wm_3 -wmp_4-s_3358453135.png "title=" 2017-11-04_145403.png "alt=" 74ad3364835b6ec7499abac2dc4c1e36.png-wh_ "/>

I want to write a blog about my habits, whatever mistakes you make!!!

This article from "Li Shilong" blog, declined reprint!

Nginx MySQL Database 5.7 system restart error