Shulou(Shulou.com)05/31 Report--

This article is about how to install the mysql 8.0.13zip package. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Mysql 8.0.13 has a data folder by default, which must be deleted, otherwise there will be an error message in the log file 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, as shown below:

Default-character-set and character-set-server cannot be written as utf-8, just as UTF8Mb4

If the previous setup failed and the MYSQL service was created

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

Enter services.msc and scroll down to find out if there are any MYSQL services set up.

If so, delete and enter sc delete MYSQL in the cmd run by the administrator (default name, if you have previously set another name, just enter another name)

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

If you confirm that there is no mysql service

Enter mysqld-- initialize-insecure

wait for

Then enter mysqld-- install

Enter net start mysql again

The MYSQL service was started successfully.

(this is my mysql zip installation memo. It must be great if I can help other great gods.)

[mysql] # set mysql client default character set default-character-set=UTF8Mb4 [mysqld] # set port 3306 port = 330 setting mysql installation directory basedir= D:\\ mysql # set mysql database data storage directory datadir= D:\ mysql\\ data # allow maximum number of connections the character set used by the max_connections=20# server defaults to the 8-bit coded latin1 character set character-set-server=UTF8Mb4# creation The default storage engine default-storage-engine=INNODB will be used when building new tables. Thank you for reading! This is the end of the article on "how to install the mysql 8.0.13zip package". I hope the above content can be of some help to you, so that you can learn more knowledge. if you think the article is good, you can share it for more people to see!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.