WIN10 Manual Installation Mysql-8.0.11-winx64.zip

1. Go to the official website to download the Mysql-8.0.11-winx64.zip installation package to the specified directory (D:\Program files\mysql)

　

2. New My.ini file in MySQL extract directory

[mysqld]# setting Port 3306=3306# Set up the MySQL installation directory Basedir=D:\Program files\mysql# Database Data storage directory (this data directory must not be created manually, otherwise error) DataDir=D:\Program files\mysql\data# Maximum number of connections allowed Max_connections= $# Number of attempts to allow connection failures. This is to prevent someone from attempting to attack the database system from the host Max_connect_errors=Ten# The default character set used by the server is Utf8character-Set-server=utf8# default storage engine to use when creating a new tabledefault-storage-engine=innodb# default to use "Mysql_native_password" Plugin authentication default_authentication_plugin=mysql_native_password[mysql]# Setting the MySQL client default character setdefault-character-Set=utf8[client]# Set the default port to use when MySQL client connects to service Port port=3306default-character-Set=utf8

2. Open Cmd.exe (C:\Windows\System32\cmd.exe) as Administrator and go to MySQL extract directory (D:\Program files\mysql\bin)

2.1 Uninstall History Service

　　　　mysqld Remove MySQL

SC Delete MySQL

2.2 This step may have a problem, if the historical reasons cause inexplicable installation failure, you can try, the consequences of self-esteem, I did not appear problems

　　　　Go to regedit ctrl+f search MySQL mysql delete all the configuration files that appear to have MySQL

3. Initialize MySQL (D:\Program files\mysql\bin), randomly generate the password, will print to the console, find a place to save ([email protected]: WQ%ASSKSH2CJ without the front space)

　　　　Mysqld--initialize--console

Mysqld-install Service Name (custom, can be used with MYSQL8, MySQL)

net start MySQL

net stop MySQL

WIN10 Manual Installation Mysql-8.0.11-winx64.zip