How to solve the zip installation problem of MySQL compressed version

Editor to share with you how to solve the MySQL compressed version of zip installation problem, I believe that most people do not know much about it, so share this article for your reference, I hope you can learn a lot after reading this article, let's go to know it!

There is a problem with installing the compressed version of mysql, that is, the service always fails to start, which takes two or three hours. After that, I really didn't understand, so I deleted the things in the registry directly.

If you have previously installed mysql, delete mysql:E:\ work\ mysql-5.7.23-winx64\ bin > sc delete mysql

To delete something from the registry, refer to this blogger: https://www.jb51.net/article/157590.htm

Because the compressed version of mysql has been used before, it may be left over.

Of course you need to download: mysql-5.7.23-winx64.zip this thing

After decompressing, you need to add my.ini files. Note: data files also need to be added by yourself.

What is written in my my.ini file

[mysql] # set mysql client default character set default-character-set= UTF8 [mysqld] sql_mode= "ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER NO_ENGINE_SUBSTITUTION "# set port 3306 port = 330mm set mysql installation directory basedir=E:\ work\ mysql-5.7.23-winx64# set mysql database data storage directory datadir=E:\ work\ mysql-5.7.23-winx64\ data# the character set used by the server defaults to 8-bit latin1 character set character-set-server=utf8# the default storage engine default- to use when creating new tables Maximum number of connections processed simultaneously by storage-engine=INNODB# It is recommended that the maximum number of connections is about 80% of the upper limit of the number of connections. Max_connections = 20 log buffer size. Since the log can be refreshed at most once a second, it is generally not required to exceed 16Minnodb_log_buffer_size = 8Mevent_scheduler = ONexplicit_defaults_for_timestamp=true.

You can go to Baidu for a specific explanation.

The preparatory work is complete.

First, the system environment variable path, add the bin directory of mysql, and notice that there is a; sign after it, such as my

Then enter mysql's bin directory as an administrator, such as my: e:\ work\ mysql-5.7.23-winx64\ bin >

After that, install mysql:

After the installation is complete, type: mysqld-- initialize-insecure-- user=mysql, the password is empty

Start

Of course, if you want to set a password, you can do this.

Note: the-proot of mysql-u root-proot must not have spaces. Then log in directly using Navicat, the mysql client.

Problem solving = attitude (cherish, selfless (can't find me), empty ship) + attribution (not all problems need to be solved, not all problems need to be solved now. Not all problems need to be solved on their own) + solutions (pyramid principle (background, conclusion, articulate supporting point of view, for point of view (background, conclusion, point of view. ) binary tree) + system loop method)

The above is all the contents of this article entitled "how to solve the zip installation problem of MySQL compressed version". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!