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