MySQL installs and starts the service, "Stop the MySQL service on the local computer after it starts." Some services stop automatically when they are not being used by other services or programs. ”

MySQL Installation and startup services, as well as the problems encountered

MySQL version: mysql-5.7.13-winx64.zip (Install-free, unzip the program folder, such as C:\Program files\mysql-5.7.13-winx64)

: Http://dev.mysql.com/get/Downloads/MySQL-5.7/mysql-5.7.13-winx64.zip

Problems encountered:

1. MySQL Service has been installed successfully, created an empty data folder, also filled in the initialization INI file, but could not start

2. Cmd execution instruction "mysql-uroot-p" prompt: "error 2003 (HY000): Can ' t connect to MySQL server on ' localhost ' (10061)"

3. When Windows service Management starts the MySQL service, it prompts: "The MySQL service on the local computer stops after it starts." Some services stop automatically when they are not being used by other services or programs. ”

4. mysql log file hint: "2016-07-12t08:14:12.661749z 0 [Note] Plugin ' federated ' is disabled. Mysql:table ' mysql.plugin ' doesn ' t exist "

Solve the problem:

In fact, these problems are due to the MySQL initialization INI file is incorrect, please note the following points

1. Cannot use the original initialization file My-default.ini directly modify, that just give us reference, in the current folder copy create a new My.ini file, fill in the good basedir and DataDir then save.

# These is commonly set, remove the # and set as required.
# basedir = C:\Program files\mysql-5.7.13-winx64
# DataDir = C:\Program Files\mysql-5.7.13-winx64\data

2. Create the Data folder, and must be an empty folder, if you have already run out some MySQL log files here, please delete all the files.

3. CMD must be in the bin directory when registering the service, or it will go wrong. Execute cmd command: Mysqld–initialize-insecure–user=mysql 

C:\Program Files\mysql-5.7.13-winx64\bin

4. mysql startup problem access denied for user ' root ' @ ' localhost ' (using Password:yes)

"Turn" http://www.cnblogs.com/gogly/p/3293328.html

After installing MySQL using sqlyogent boot is prompted "Access denied for user ' root ' @ ' localhost ' (using Password:yes)", start I still because it is a password problem, Later on the Internet check to know the root authority problem, I think it may be because of the Win7 system I do not use as an administrator in the installation, so root role does not have permissions, from the Internet to find a solution to solve, here to record: 1. Administrator login system, stop the MySQL service or end the MYSQLD-NT process; 2. Go to the command line and come to the MySQL installation directory. Assuming that the installation directory is d:\mysql\, CMD enters the command line; 3. Run D:\Program files\mysql\mysql Server 5.5\bin\mysqld-nt--skip-grant-tables start MySQL, turn off check of permissions; 4. Run D:\Program files\mysql\mysql Server 5.5\bin\mysqladmin-u root flush-privileges password "newpassword" to reset the root password; 5. Restart the MySQL service;

MySQL installation and startup service, "Stop after the MySQL service on the local computer starts. Some services stop automatically when they are not being used by other services or programs. The