MySQL 5.7.14 Installation-free configuration method Tutorial

For reference only

First, download

1. Go to MySQL website and download mysql-5.7.14,:http://dev.mysql.com/downloads/mysql/

2. Extract the downloaded files to the custom directory

Second, the configuration file

1. First configure the environment variable path, specifically no longer describe

2. Copy the My-default.ini under the decompression path and modify the name to My.ini

# Basedir = E:\mysql (here is the MySQL file path, custom)
# DataDir = E:\mysql\data (here is the MySQL file path, custom)
# port = 3306

Second, initialize the database, configure the relevant information

1. Run the Windows command line as an administrator
2. Go to MySQL's unzip directory and make sure to go to the bin directory , otherwise there will be an error later:

Example: E:\mysql\bin

Perform mysqld--initialize--user=mysql--console initialization, and finally generate Root's initial password

Remember the initial password.

Continue running command: mysqld--install mysql Successful installation service

Start service: net start MySQL

The user may receive the following error: System error 2 has occurred. The system could not find the specified file.

The reason is that when you run the Install Service command: mysqld--install MySQL, we do not enter the bin directory for installation.

solution: go to the bin directory, first remove service, Run command mysqld--remove

Then reinstall the MySQL service, run the command mysqld--install MySQL

Command line Input mysql-u root-p and then enter the initial password you just initialized

Then modify the database password: Alter user ' root ' @ ' localhost ' identified by ' 123 '; (123 for Custom)

If you have questions, please check

Http://www.jb51.net/article/90259.htm

MySQL 5.7.14 Installation-free configuration method Tutorial