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

Mysql download installation configuration 5.7.20 / 5.7.21 for your reference, the details are as follows

1. Download mysql, download address

Select the operating system and version. I am a 64-bit win10. After clicking Download, I will jump to the Oracle login page to request login before downloading:

Download after login:

2. Decompress after the download is completed:

3. Create a my.ini file under the mysql directory, as shown in the figure above. The contents of the file are as follows, and the basedir and datadir are modified to the corresponding address:

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir=D:/tools/ent/db/mysql-5.7.20-winx64 # set mysql database data storage directory datadir=D:/tools/ent/db/mysql-5.7.20-winx64/data # maximum number of connections allowed max_connections=200 # words used by the server The character set defaults to the 8-bit latin1 character set character-set-server=utf8 # the default storage engine default-storage-engine=INNODB that will be used when creating new tables

4. Cmd goes to the bin directory and executes mysqld-- initialize-insecure

\ mysql-5.7.20-winx64\ bin > mysqld-- initialize-insecure

5. Then execute mysqld-install

Mysql-5.7.20-winx64\ bin > mysqld-install

Prompt Service successfully installed, that is, the installation is successful

6. Start the service

D:\ tools\ ent\ db\ mysql-5.7.20-winx64\ bin > net start mysql

7. Stop the service

D:\ tools\ ent\ db\ mysql-5.7.20-winx64\ bin > net stop mysql

8. Log in to mysql

D:\ tools\ ent\ db\ mysql-5.7.20-winx64\ bin > mysql- uroot-p Enter password: * Welcome to the MySQL monitor. Commands end with; or\ g. Your MySQL connection id is 6 Server version: 5.7.20 MySQL Community Server (GPL) Copyright (c) 2000, 2017, Oracle and/or its affiliates. All rights reserved. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or'\ h' for help. Type'\ c'to clear the current input statement. Mysql > show databases; +-+ | Database | +-+ | information_schema | | api | | ibase4j | | jpress | | mysql | | performance_schema | | srmhome | sys | | wordpress | +-+ 9 rows in set (0.00 sec) mysql >

Done!

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.