MySQL 5.7.17 installation and configuration method graphic tutorial under win7

I would like to share with you the graphic tutorial on how to install MySQL 5.7.17 under Windows 7.

1. Download the installation package

Please download it from https://dev.mysql.com/downloads/mysql/

There are two types of packages: ZIP package and MSI package. It is recommended that beginners choose ZIP package download to help them familiarize themselves with MySQL.

2. Unzip the MySQL compressed package

After downloading, unzip it and put it in the directory where you want to install it, such as: E:\Mysql\mysql-5.7.17-win32

3. Create and modify the configuration file my.ini

Create a new my.ini file in the corresponding installation directory. You can copy a copy of my-default.ini and change the file name to my.ini, and modify the content of the my.ini file to:

############################

[mysql]
# Set the default character set of the mysql client to default-character-set=utf8 
[mysqld]

#Set port 3306 port = 3306

# Set the installation directory of mysql basedir=E:\Mysql\mysql-5.7.17-win32

# Set the storage directory of mysql database data datadir=E:\Mysql\mysql-5.7.17-win32\data

# Maximum number of connections allowed max_connections=200

# The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8

# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

################################

4. Create a new folder data in the E:\Mysql\mysql-5.7.17-win32 directory

5. Add environment variables

Right-click "Computer" properties, go to the system interface and select "Advanced System Settings", and click "Environment Variables" in "Advanced"

Edit the PATH system variable and add E:\Mysql\mysql-5.7.17-win32\bin; in the first position (note the semicolon)

or:

Create a new variable named "MYSQL_HOME" in the system environment variables. Variable value: "E:\Mysql\mysql-5.7.17-win32"

Edit the existing environment variable "Path" and add "%MYSQL_HOME%\bin" at the end.

6. Uninstall, reinstall, initialize MYSQL, and finally start the MYSQL service.

Open the cmd command line as an administrator, enter the bin directory where the database is installed, and enter the following commands in sequence:

 E:\Mysql\mysql-5.7.17-win32\bin>mysqld --install //Install mysql service E:\Mysql\mysql-5.7.17-win32\bin>mysqld --initialize //Must initialize E:\Mysql\mysql-5.7.17-win32\bin>net start mysql //Start mysql service

7. Log in to MySQL

Execute in the bin directory: mysql -u root -p You will be asked to enter the password

The password is randomly assigned during initialization in the previous step. You need to go to the data directory to find the .err file and open it with text, as follows:

8. Change password:

After successful login, alter user 'root'@'localhost' identified by 'new password';

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.