Installation-free version of MySQL environment build (2016-09-19)

1. Download the required MySQL version on the website, the installation version is very simple no longer say

Website download link

2. Setting Environment variables

2.1 Unzip the downloaded package and remember the path where the bin folder is located;

2.2 In the environment variables, advanced system settings, properties, My Computer , configure the path of the Bin folder to path, separating the different environment variables with semicolons (;)

　　

3. Configure MySQL

3.1 Locate the MySQL decompression path, locate the My-default.ini file, and modify the Basedir and DataDir in the file.

Basedir:mysql the decompression path

Datadir:mysql the path of the data folder (the data folder is stored to initialize the database table, not automatically created, no need to manually create new)

　　　　

3.2 Open cmd ( preferably run as Administrator ), switch to the path of the bin folder in MySQL and then execute the Initialize command

3.2.1 Toggle Drive Letter , drive letter:

path of the bin folder in CD MySQL, 3.2.2 Switch path

3.2.3 Execute initialization command,mysqld--initialize

　　　　

3.2.4 The initial password is generated after the initialization is successful, the password is stored in the *.err file (network) under the Data folder of the DataDir configuration

　　　　

3.3 Installing the MySQL service

As with initialization, switch to the path of the bin directory in MySQL and execute the installation command

　　　　

3.4 Turn on MySQL service ( must run cmd as Administrator)

3.4.1 Open service does not need to switch directories, directly run net start MySQL can

　　　　　　

3.4.2 MySQL for the service name, the installation version after the installation of the service name may be mysql6, you can look at the service

　　　　　　　

3.5 After the service opened successfully, directly connected to the MySQL database to see if the success, after successful change the login password.

　　　　

Change Password command: Alert user ' root ' @ ' localhost ' identified by ' new password '

　　　　

　　

Installation-free version of MySQL environment build (2016-09-19)