WIN10 install MySQL free install version

One: Download and unzip

This is not much to say https://dev.mysql.com/downloads/mysql/, simple very

Second: MySQL root directory under new My.ini

[mysql]# set MySQL client default character set Default-character-set=utf8 [mysqld] #设置3306端口port = 3306 # Set the installation directory for MySQL Basedir=c:\program files\mysql-5.7.18-winx64# set the data storage directory for the MySQL database Datadir=c:\program files\mysql-5.7.18-winx64\data# allow the maximum number of connections Max_ The character set used by the connections=200# service side defaults to a 8-bit encoded latin1 character set character-set-server=utf8# the default storage engine that will be used when creating a new table default-storage-engine= INNODB

　　

Second: Install the MySQL service and initialize it

Admin mode run PowerShell, and then navigate to the MySQL root directory, run Mysqld-install MySQL MySQL for the service name

Run mysqld--initialize to initialize MySQL, the data folder will be generated automatically, the process is a bit slow, please wait patiently

Where Zoulu.err is named after the machine name, which contains the MySQL initial password

Four: Change Password

Open Zoulu.err (different for everyone), find

2017-06-22t13:33:36.505799z 1 [Note] A temporary password is generated for [email protected]: L (fbz+i-,0>g

Local Host: The following is the initial password.

Run the net start MySQL startup service, or go to the service management interface to start

Run Mysql-u root-p; Then enter the password to login MySQL login MySQL

Run the show databases; test it and you'll be prompted to reset your password

Run alter user ' root ' @ ' localhost ' identified by ' root '; change the password to root, change the other values can also

Then run the show databases;

WIN10 install MySQL free install version