mysql5.7 the MySQL service on the local computer stops after the startup problem is resolved

mysql5.7 stop after the MySQL service on the local computer starts. Problem: MySQL service under CMD does not start any error law startup service does not report any errors

Starting in the service is

Come on in the morning. Found the project has a problem, the general Apache MySQL restart a bit is OK. Apache restarted, but MySQL could not restart, it said he stopped. Start in the service, this is great .... Error. On the top of the dead and alive do not come .... The project is still not running up, customer service there called to urge ....　　Anxious to die, Baidu has a lot of methods. Many of them need to be reinitialized. Mysqld--initialize

Can't initialize AH ... Initialized database, database, configuration, index, various problems ....　　Head of a wide variety of Baidu, a variety of tests, urgent also no way, slowly find. Let's start with the mistake. MySQL does not have to know his error log under that folder. And then I saw that there was an order under CMD.mysqld--consoleSee the error message

Then find this configuration in the My.ini. Look at this note.

Max_connect_errors–mysql Performance Parameters Detailed

Parameter format max_connect_errors = 10 configuration Note When this value is set to 10 o'clock, it means that if a client attempts to connect to this MySQL server but fails (such as a password error, and so on) 10 times, MySQL will unconditionally force this client connection to be blocked. If you want to reset the value of this counter, you must restart the MySQL server or execute the mysql> FLUSH HOSTS; When this client successfully connects to a MySQL server, the max_connect_errors for this client are zeroed out. Impact and error forms if the settings of the max_connect_errors are too small, the Web page may prompt that the database server cannot be connected, and the MySQL command via SSH will return error 1129 (00000): Host ' Gateway ' is Blocked because of many connection errors; Unblock with ' mysqladmin flush-hosts ' error. function and function in general, it is recommended that the database server not listen to connections from the network, only through the sock connection, this can prevent the majority of attacks against MySQL, if you have to turn on the MySQL network connection, it is better to set this value to prevent the brute-load password attack means originally due to the Max_ Connect_errors=10 to the 100 after he was transferred to the ";" number, resulting in the inability to restart. and the number of connections is too big to make him smaller. Just get up and talk. Test it up. Summary: Encounter problems do not flying blind, or to have ideas, see which error, reported what wrong. and see how it's solved.

mysql5.7 the MySQL service on the local computer stops after the startup problem is resolved