Shulou(Shulou.com)06/01 Report--

Editor to share with you how to solve the failure of mysql zip installation, I believe 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!

The solution to the failure of mysql zip installation: first download MySQL and extract it, then create a new file "my.ini" under the decompressed path, then add the code "default-character-set=utf8...", and finally complete the installation through the mysqld install command.

MySQL5.7.17, which now seems to be the latest version, download address

Here you can choose your own platform version, choose your own download, mine is the windows version. It should be more or less the same.

Download the file here to talk about the ZIP version, the MIS version I have not tried and do not know.

As a reminder here, it's best to download a version without debug, because I did it once, and the installation failed, because there was no ini file, which led to a lot of problems.

Just put it on an established file after the decompression is finished.

The extracted file has a default configuration file (my-default.ini). Create a new file under the extracted path: my.ini (copy the my-default.ini file, and then change it above), copy the following code, and F:\ mysql appears twice in the code. This is the decompression path of my MySQL, and you can replace it according to your own path.

[mysql] # set mysql client default character set default-character-set=utf8 [mysqld] # set port 3306 port = 3306 # set mysql installation directory basedir= "F:\ mysql" # set mysql database data storage directory datadir= "F:\ mysql\ data" # allow maximum number of connections the character set used by the max_connections=200# server defaults to 8-bit coded latin1 character set character-set-server=utf8# creation The default storage engine default-storage-engine=INNODB that will be used for new tables

Run the command prompt as an administrator (right the icon in the lower left corner and forget the name, where you have to run the command prompt as an administrator, and you must use this instead of that + R), change to the bin directory of MySQL, enter the mysqld install command (note that it is mysqld rather than mysql) and enter to install MySQL, as shown in the following figure: because I have finished downloading and installing, it shows that the service already exists Yours should show that the service was created successfully.

Now that the installation is complete, we have one last step to start running again.

Enter net start mysql to start MySQL and net stop mysql to turn off the MySQL service. The same question, mine has been completed, yours should be starting, starting successfully.

Here another configuration of environment variables, different versions of Window environment variables are not the same place, roughly in the system and security-system-advanced system settings-environment variables, we find a path environment variable here, click Edit, and then click to edit the text, in his path to add his own MySQL bin path; be sure to remember that after each path segment must add ";".

Some people may have some problems here, which I am very unfortunate to encounter. Some people will have a problem is startup failure.

Solution: after installing MySQL, open the cmd command window, go to the bin directory in the MySQL installation directory, and enter the following command to enter: mysqld-initialize-insecure-user=mysql

After executing the above command, MySQL will create a data folder and set up a default database. The login user name is root and the password is empty, and then you can start the mysql service with the command net start mysql.

After that, I did it myself. But under cmd. It's not a graphical interface. The two better graphical interfaces are workbench and sqlyog developed by MySQL itself, followed by a tutorial on installing workbench.

The above is all the contents of how to solve the failure of mysql zip installation, 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!

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.