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

This article will explain the operation steps of mysql5.7.20 zip installation for you in detail. The editor thinks it is very practical, so I share it with you for reference. I hope you can get something after reading this article.

Mysql 5.7.20 zip installation, the details are as follows

(1) decompress the package and wear the data folder and my.ini file.

The directory I unzipped is D:/software/mysql-5.7.21-winx64.

Create a data directory and create or modify a my.ini configuration file.

The zip file I downloaded didn't contain my.ini or default.ini either, so I had to create a configuration file manually.

The following is the configuration file I copied from the Internet, which can be tested by myself, just need to change datadir and basedir

[client] port=3306 default-character-set=utf8 [mysqld] # set the installation directory of mysql basedir = D:/software/mysql-5.7.21-winx64 # set the data directory of mysql datadir = D:/software/mysql-5.7.21-winx64/data character_set_server=utf8 sql_mode=NO_ENGINE_SUBSTITUTION,NO_AUTO_CREATE_USER # enable query cache explicit_defaults_for_timestamp=true skip-grant-tables

(2) configure the environment variable (bin) to add D:\ software\ mysql-5.7.21-winx64 to the path

(3) mysqld-- initialize-- user=mysql-- console cmd uses administrator privileges

The last line is a randomly generated password

(4) mysqld-- install installation service / / prompt if the installation is successful

(5) enable mysql service

Net start mysql

(6) change (setting, if there is no initial password is to set the password) there are many ways to change the password on the Internet, but this is the only one I have tried successfully.

Set password for 'root' @' localhost' = password ('password')

Possible problems with installation:

1.mysqld: Can't create directory'd: oftware\ mysql-5.7.21-winx64\ data\'(Errcode: 2-No such file or directory)

Changing the "\" in the basedir and datadir paths in my.ini to "/" can solve this problem.

2.ERROR 2003:Can't to MySQL server on 'localhost' (10061) or a sentence with a similar meaning to this sentence. Is to prompt that the MySQL service is not started

For mysql error solution, click to view: the solution to the ERROR 2003 (HY000) problem when mysql starts.

3. Mysqld install reported an error Install/Remove of the Service Denied

Solution: just start cmd with administrator privileges

4. An error was reported during login: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

Maybe the password was entered incorrectly.

This is the end of this article on "steps for mysql5.7.20 zip installation". 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, please share it out 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.