mysql8.0 windows x64 zip Package Installation Configuration Tutorial

mysql 8 windows Version zip Installation Steps (Download Address)

1. Extract the ZIP file to the specified directory: for example, D:\ mysql-8. 0.11-winx64
2. Create a new my. ini configuration file and paste and modify the following contents: (1) baseidr path (2) datadir path

[mysql]
#  Settings mysql Client default character set 
default-character-set=utf8 
[mysqld]
# Settings 3306 Port 
port = 3306 
#  Settings mysql Installation directory of 


basedir=D:\\mysql-8.0.11-winx64
#  Settings mysql The storage directory of the data in the database 
datadir=D:\\mysql-8.0.11-winx64\\data


#  Maximum number of connections allowed 
max_connections=200
#  The character set used by the server defaults to UTF8
character-set-server=utf8
#  Default storage engine to be used when creating new tables 
default-storage-engine=INNODB

3. The cmd command enters the mysql bin directory specified by the console as an administrator to run the mysqld install command. Note: You need to run as an administrator here!

4. Start mysql service after successful installation: net start mysql

5. If an error is reported: Some people say that mysqld-initialize method needs to be implemented from 5.7. 6 (MySQL installation prompt "Please type NET HELPMSG 3534 for more help").

The solution is as follows:

1) Execute the mysqld-remove command to remove the previous incorrect installation, or you will be prompted that it has been installed

2) After executing the command mysqld-initialize-user=mysql-console and remembering the default password for localhost. (If an error is reported, please delete the original data directory and let the system automatically re-create it.)

Then execute mysqld install, then execute net start mysql, start MySQL, and cut 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'

Wonderful topic sharing: mysql installation tutorials for different versions mysql5.7 installation tutorials for different versions mysql5.6 installation tutorials