MySQL 5.7.20 zip installation tutorial

MySQL 5.7.20 zip installation, the specific contents are as follows

(1) Unzip the compressed package and create 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 the my.ini configuration file.

The zip file I downloaded also did not include a my.ini or default.ini, so I had to create a configuration file manually.

Below is the configuration file I copied from the Internet. It works after personal testing. You only 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 mysql data directory 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 environment variables (bin) 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 //A prompt will appear if the installation is successful

(5) Start the MySQL service

 net start mysql

(6) Change (set, or set password if there is no initial password) password. There are many methods available online, but this is the only one I have tried successfully.

set password for 'root' @'localhost' = password('password');

Possible installation problems:

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<HY000>: Can't reach MySQL server on 'localhost'(10061) or something similar. It means that the MySQL service is not started

For solutions to mysql error, click to view: Solutions to ERROR 2003 (HY000) when starting mysql

3. mysqld install reports an error: Install/Remove of the Service Denied

Solution: Just start cmd with administrator privileges

4. Error when logging in: ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

The password may be entered incorrectly.

The above is the full content of this article. I hope it will be helpful for everyone’s study. I also hope that everyone will support 123WORDPRESS.COM.