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

1. Extract to the location you want to install, and create the my.ini file.

The content of my.ini is as follows

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir=D:\ Program Files\ mysql-5.7.21-winx64# set mysql database data storage directory datadir=D:\ Program Files\ mysql-5.7.21-winx64\ data# maximum number of connections the character set used by the max_connections=200# server defaults to 8 bits Encoded latin1 character set character-set-server=utf8# the default storage engine default-storage-engine=INNODB that will be used when creating new tables

2. Open the cmd command line with administrator privileges

3. Change to the bin folder directory of the installation directory, and initialize the data folder, because there is no data folder in the extracted directory, so you don't have to create it manually.

-- the initialization command is as follows

Mysqld-- defaults-file= "D:\ Program Files\ mysql-5.7.21-winx64\ my.ini"-- initialize-insecure

-- install MySQL service

Mysqld-install MySql57

-- start MySql service

Net start MySql57

4. Change the password of the initial root account. There is no password by default. Enter the command directly.

Mysql-u rootshow database;use mysql;UPDATE user SET authentication_string=PASSWORD ("yourpassword") WHERE user='root';FLUSH PRIVILEGES;QUIT

Summary

The above is the configuration method under the installation-free version win10 of MySql 5.7.21 introduced to you by the editor. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. Thank you very much for your support to the website!

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.