About MySQL 8.0.13 zip package installation method

MySQL 8.0.13 has a data folder by default. This folder must be deleted, otherwise there will be a log file prompt error when installing the service:

Failed to find valid data directory.

Data Dictionary initialization failed.

Also, create a new my.ini file in the mysql folder with the following content:

default-character-set and character-set-server cannot be written as utf-8, just write them as UTF8Mb4

If the previous setup failed but the MYSQL service was created,

Open cmd as an administrator. (In fact, open cmd directly first, then open the task manager, find the location of cmd and run it as an administrator.)

Type services.msc and scroll down to see if there is a MYSQL service set up.

If there is, delete it by typing sc delete MYSQL (default name, you may have set another name before, just enter the other name) in the cmd run by the administrator

Of course, you can also enter mysqld -remove MYSQL in the mysql bin directory.

If you confirm that there is no mysql service

Type mysqld --initialize-insecure

wait

Then enter mysqld --install

Then enter net start mysql

The MYSQL service was started successfully.

(This is my MySQL zip installation memo. If it can help other experts, it will be great.)

[mysql]
# Set the default character set of the mysql client to default-character-set=UTF8Mb4
[mysqld]
# Set port 3306 port = 3306
# Set the installation directory of mysql basedir = D:\\mysql  
# Set the storage directory of mysql database data datadir = D:\\mysql\\data 
# Maximum number of connections allowed max_connections=20
# The default character set used by the server is the 8-bit latin1 character set character-set-server=UTF8Mb4
# The default storage engine that will be used when creating a new table default-storage-engine=INNODB

Summarize

The above is the editor's introduction to the installation method of MySQL 8.0.13zip package. I hope it will be helpful to everyone. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!