MySQL service failed to start problem

"MySQL service failed to start" issue when reinstalling MySQL today

Download MySQL installer (https://cdn.mysql.com//Downloads/MySQLInstaller/mysql-installer-community-5.7.18.1.msi) from MySQL website and install it all the way. When the installation is complete, "MySQL service cannot start" appears when you enter "net start MySQL" in Cmd.

See why with "Mysqld-console"

Cause: The installation directory and the data directory are no longer a place to install directories in the C:\Program files\mysql\mysql server 5.7\,data directory in C:\ProgramData\MySQL\MySQL server 5.5\ Data Therefore, the configuration file is not in the installation directory, unable to create the data file, unable to start the MySQL service.

Move the data directory to the installation directory. Still can't start

See why:

Workaround: Move the My.ini in the data directory to the C:\Program files\mysql\mysql Server 5.7\bin directory to open the service. (Re-enter the command after you turn off Mysqld.exe in the task Manager)

！！！ The installation process seems to have a path selected, you should be able to put the installation directory and the data path in the same directory. (If you fill in the default options, a big pit ah, for a long time)

If you choose to reload and then you will encounter the registry problems, specific reference blog installation reinstall MySQL, configure MySQL can not start the service solution

Reference Blog: http://blog.csdn.net/u014296452/article/details/54971928

Http://www.cnblogs.com/zhouhb/p/4596998.html

MySQL service failed to start problem