Shulou(Shulou.com)06/01 Report--

The following brings you about using picture and text to demonstrate the installation and configuration of winx64.zip in Mysql5.7.17. If you are interested, let's take a look at this article. I believe that after reading the demonstration of installation and configuration of winx64.zip in Mysql5.7.17 with picture and text, it will be of some help to you.

1. Download mysql-5.7.17-winx64.zip

Link: https://pan.baidu.com/s/1tTqT2sn7cEaOwEvrQ-LrHg password: i444.

two。 Extract to a folder (for example):

Extract to the current folder

3. Modify the configuration file:

Open the extracted folder (the location of the configuration file in this example is D:\ Development\ mysql\ mysql-5.7.17-winx64\ mysql-5.7.17-winx64\), delete my-default.ini, and create a new my.ini

Modify the my.ini as follows:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] skip-grant-tables# setting 3306 port port = 3306 # set mysql installation directory basedir=D:\ Development\ mysql\ mysql-5.7.17-winx64\ mysql-5.7.17-winx64# set mysql database data storage directory datadir=D:\ Development\ mysql\ mysql-5.7.17-winx64\ mysql-5.7.17-winx64\ data# Maximum number of connections allowed the character set used by the max_connections=200# server defaults to the 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

Note:

Basedir= your own mysql installation path

Directory where datadir=mysql resides\ data

4. Configure the environment variable Path

Right click on my computer-> Properties-> Advanced system Settings-> Environment variables-> find Path in the system variables

Add the path where bin under the mysql directory is located to the end of Path (do not overwrite the original value of Path):

; D:\ Development\ mysql\ mysql-5.7.17-winx64\ mysql-5.7.17-winx64\ bin

5. Open cmd with administrator privileges

Click start to search for cmd

Right-click cmd.exe to run as an administrator

6. Enter mysql's bin directory in cmd

Then enter:

D:\ mysql-5.7.9-winx64\ bin > mysqld-install installed successfully, enter: d:\ mysql-5.7.9-winx64\ bin > mysqld-- initialize to start the mysql service: d:\ mysql-5.7.9-winx64\ bin > net start mysql

7. After startup, do not close the current cmd. Enter mysql directly. After entering the mysql, enter the following statement to set the user password:

Mysql > update mysql.user set authentication_string=password ('newpassword') where user='root'

8. When the setup is complete, exit exits mysql, closes the cmd window, then opens the my.ini file and comments out the skip-grant-tables:

# skip-grant-tables, save the file, open the cmd window (open as an administrator), net stop mysql stop the mysql service, and then restart the mysql service with net start mysql.

9. Under the cmd window, enter mysql-u root-p

Enter the password to log in

10. Log in successfully, enter mysql > SET PASSWORD = PASSWORD ('your_new_password'), and then enter show databases; to view all current databases

11. At this point, all configurations are complete.

Read the above on the use of graphics and text to demonstrate the installation and configuration of winx64.zip in Mysql5.7.17 decompressed version of the details, whether there is anything to gain. If you want to know more about it, you can continue to follow our industry information section.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.