mysql5.7.1.3 installation instructions and issues that arise

1. Can go to the official website to download http://dev.mysql.com/downloads/mysql/

Link: http://pan.baidu.com/s/1hsO5OX2 Password: jmc6

2. Unzip to the folder my directory is C:\mysql\mysql-5.7.13-winx64

3. Add environment variable C:\mysql\mysql-5.7.13-winx64\bin

4. Change My-default.ini to My.ini content and Data folder

[mysql]# set MySQL client default character set Default-character-set=utf8 [mysqld] #设置3306端口port = 3306 # Set the installation directory for MySQL basedir=c:\\mysql\\ mysql-5.7.13-winx64# set the data storage directory for the MYSQL database datadir=c:\\mysql\\mysql-5.7.13-winx64\\data# the maximum number of connections allowed max_connections=200# The character set used by the service side defaults to the 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine that will be used when creating a new table Default-storage-engine=innodb

The path here is \ \ ' unsuccessful

5. Initializing the database

Run cmd as administrator, execute command mysqld--initialize (Initialize database) to initialize 1 text files,

and put the following command in a single line: SET PASSWORD for ' root ' @ ' localhost ' = PASSWORD (' root '); Save the file with any name.

In this case, the file is C:\Mysql\init.txt. Execute mysqld--init-file=c:\mysql\init.txt on the command line

6 Execute command mysql-u root-p, press ENTER, enter the password as root, you can enter MySQL.

7 run cmd as Administrator, enter mysqld--install to install the MySQL service.

8 Startup error

9 exiting the MYSQLD service can end the Mysqld.exe process through Task Manager.

the error is due to the inability to find the MySQL executable file, by modifying the registry for processing, to the registry hkey_local_mechine---SYSTEM---currentcontrolset---services Change the value of the Find MySQL entry, and then modify the path.
Press with "Win" key +r key, bring up "run" window, enter regedit to bring up the registration form
Locate the hkey_local_mechine---SYSTEM---currentcontrolset---services

Find MySQL in Services

Change the ImagePath value to the path where Mysql\bin is located, such as in this example: "C:\mysql\mysql-5.7.13-winx64\bin\mysqld"

The change is over at this point.

To enter MySQL later, first start the MySQL service by executing net start MySQL from the command line or by starting MySQL under the service in Computer Management and entering Mysql-u root-p at the command line.

mysql5.7.1.3 installation instructions and issues that arise