Graphic tutorial on how to install and configure mysql5.7.17 in win7, win7mysql5.7.17

Graphic tutorial on how to install and configure mysql5.7.17 in win7, win7mysql5.7.17

Install MySQL5.7.17 graphic tutorials under win7 and share them with you.

1. Download the installation package

Please in the following https://dev.mysql.com/downloads/mysql/

There are two types of packages: ZIP package and MSI. We recommend that you download a ZIP package to familiarize yourself with MySQL.

2. decompress the MySQL package

Decompress the downloaded package and place it under the directory to be installed, such as: E: \ Mysql \ mysql-5.7.17-win32

3. Create and modify the configuration file my. ini

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

########################### [Mysql] # Set the default character Set of the mysql client default-character -set = utf8 [mysqld] # set port 3306 to port 3306 # set the mysql installation directory basedir = E: \ Mysql \ mysql-5.7.17-win32 # Set the mysql database data storage directory datadir = E: \ Mysql \ mysql-5.7.17-win32 \ data # maximum number of connections allowed max_connections = 200 # the character set used by the server defaults to the 8-bit latin1 character set character-set-server = utf8 # default storage engine default-storage-engine = INNODB ############################## ##

4. Under the E: \ Mysql \ mysql-5.7.17-win32 directoryCreate folder data

5. Add Environment Variables

Right-click "computer" properties, select "Advanced System settings" on the system interface, and click "environment variables" in "advanced"

Edit the PATH of the system variable and add E: \ Mysql \ mysql-5.7.17-win32 \ bin at the beginning (note the semicolon)

Or:

Create a variable named "MYSQL_HOME" in the system environment variable. 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, and finally enable the MYSQL service.

Open the cmd command line as an administrator, go to the bin directory installed in the database, 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 // be sure to initialize E: \ Mysql \ mysql-5.7.17-win32 \ bin> net start mysql // start mysql Service

7. log on to MySQL

Run mysql-u root-p in the bin directory, and 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 in text, as shown below:

8. Change the password:

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

The above is all the content of this article. I hope it will be helpful for your learning and support for helping customers.