1. Download address:https://dev.mysql.com/downloads/mysql/5.7.html#downloads

2 After downloading, you can just put the decompressing content to a directory. Mine is the following directory (if you put it on the C drive, you may involve permissions when modifying the INI file. \ mysql

As shown below: At this time, there is no Data directory and INI file in the file at this time

3. Create a new My.ini file in the E: \ MySQL directory, copy the following content

[mysqld]

# Set 3306 ends

port = 3306

# Set the installation directory of MySQL

basedir=E:\mysql

# Set the data storage directory of the data of mysql database

datadir=E:\mysql\data

# Allow the maximum number of connections

max_connections=200

# The character set used by the server defaults to the latin1 character set of 8 bit encoded

character-set-server=utf8

# The default storage engine will be used when creating a new table

default-storage-engine=INNODB

sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

[mysql]

# Set mysql client default character set

default-character-set=utf8

4. The following configuration environment variables:

Computer Properties-“Advanced System Settings-“

Click on the environment variable

Create a new variable name in the system variable part: MySQL_HOME, variable value: E: \ mysql

Set PATH and add a new BIN directory in Path (note the previous seminars;)

5.Mysql installation process:

Administrator’s identity runs CMD

Enter the following directory: E: MySQL \ Bin

1 Run mysqld –nstall installation service console prompt: Services SuccessFully Installed If it runs mysqld –nstall installation service, it exists existing

Enter MySQLD -Remove, remove the previously installed Mysql running mysqld –nstall again

2 Running command: MySQLD-Initialize (at this time it will generate DATA directory)

3 Start the service net start mysql

4 Modify the password

The first step:net stop mysql (stop service)

Step 2:Repeat MySQLD-SKIP-GRANT-Tables to open the password-free MySQL Server.

3:Newly open a terminal, enter mysql -u root -p into MySQL

Step 4: Then update the password of the root account to ‘root’

command: update mysql.user set authentication_string = password (“root”) where user = “root”;

Step 5:Perform Flush Privileges refresh permissions.

Step 6: Quit;

Step 7:Enter mysql -u root -p into mysql and enter the password root

Step 8: Change the password again:

step 1: SET PASSWORD = PASSWORD(‘your new password’);

step 2: ALTER USER ‘root’@’localhost’ PASSWORD EXPIRE NEVER;

step 3: flush privileges;

Step 9: Open CMD again to log in again

4 4 4! 5.7.23 Database installation is successful!

/Article/Details/81605640? UTM_SOURCE = Copy