MySQL 8 Windows version Zip method installation steps

MySQL 8 Windows version Zip method installation Steps (: https://dev.mysql.com/downloads/mysql/)
1. Unzip the zip file to the specified directory: D:\mysql-8.0.11-winx64
2, create a new My.ini configuration file and paste the following changes: (1) Baseidr path (2) DataDir path
[MySQL]
# Set the MySQL client default character set
Default-character-set=utf8
[Mysqld]
#设置3306端口
Port = 3306
# set up the MySQL installation directory


Basedir=d:\\mysql-8.0.11-winx64
# Set up a storage directory for MySQL database data
Datadir=d:\\mysql-8.0.11-winx64\\data


# Maximum number of connections allowed
max_connections=200
# The default character set used by the server is UTF8
Character-set-server=utf8
# The default storage engine that will be used when creating a new table
Default-storage-engine=innodb




The 3,cmd command runs the mysqld install command as an administrator into the MySQL bin directory specified by the console. Note: You need to run as Administrator here!
4. Start MySQL service after successful installation: net start MySQL
5, if error: It is said that the Mysqld--initialize method (http://www.mamicode.com/info-detail-1150164.html) needs to be executed starting from 5.7.6. Here's how to fix it:


1) Execute the mysqld-remove command to remove the previous error installation, otherwise you will be prompted to install


2) Execute mysqld--initialize--user=mysql--console command and remember the default password for localhost. (If the error, please delete the original data directory, let the system automatically re-create)
Execute mysqld install again, then execute net start MySQL start MySQL, all OK
6. Log in to MySQL with the default password and execute the following command to change the password: ALTER USER ' root ' @ ' localhost ' identified with mysql_native_password by ' root '




The perfect installation is complete!

MySQL 8 Windows version Zip method installation steps