Detailed installation tutorial of mysql5.7.19 decompressed version (with pure cracked Chinese version SQLYog)

Mysql5.7.19 version is a new version launched this year. The recent versions of MySQL are no longer installation versions, but decompressed versions. This has caused a lot of trouble and dug a lot of holes for comrades. From the perspective of user usability alone, this is really a bit anti-human!

The author also tried again and again for almost an hour before he successfully got it done. In the process, he also searched a lot of tutorials on the Internet, but unfortunately many of them were the same. So he simply recorded it himself to avoid repeating the same mistake next time.

In addition: There are many kinds of graphical tools for MySQL. I feel that SQLYog is easier to use. This is purely my personal feeling. Please don’t criticize me if you don’t like it! Comes with a cracked version of SQLYog.

The author's environment:

win10 x64

1. Download the installation package

Visit MySQL official website https://www.mysql.com/

Download in the following order:

2. Unzip to a custom directory

After decompression, it is as follows:

3. Edit my.ini

As shown in the figure above, there is no my.ini file after decompression, so you need to write it yourself.

The content is as follows. Simply create a new my.ini document and copy and save the following content:

[Client]#
Set port 3306 port = 3306 [mysqld]#
Set port 3306 port = 3306# 
Set the installation directory of MySQL basedir=%MYSQL_HOME%# 
Set the storage directory of mysql database data datadir=%MYSQL_HOME%\data# 
The maximum number of connections allowed is max_connections=200# 
The default character set used by the server is the 8-bit latin1 character set character-set-server=utf8# 
The default storage engine that will be used when creating a new table default-storage-engine=INNODB sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysql]# 
Set the default character set of MySQL client to default-character-set=utf8#
forget the password#
skip-grant-tables[WinMySQLAdmin]%MYSQL_HOME%\bin\mysqld.exe 

After editing, copy the my.ini file to the bin/directory.

4. Configure environment variables

You need to pay attention when configuring environment variables. For some reason, the author is using the latest version of win10. When configuring environment variables, if you use %*****_HOME%, it will not take effect. You can only configure the path directly:

Configure MYSQL_HOME:

5. Installation

Find C:\Windows\System32\cmd.exe, run it as administrator, administrator, administrator, and open the bin\ directory:

Execute the commands separately

mysqld --installmysqld --initialize-insecurenet start mysql

The execution results are as follows:

Check the decompression directory to see that the data folder has been generated

6. Change password

Execute the following commands in sequence. Note that the root password for the first installation is blank. You need to reset the password. I have also tested resetting the password during login, but it does not work. It is a bit troublesome to use the forgotten password configuration, so it is not recommended.

mysql -u root -puse mysql;
update user set authentication_string=password('root') 
where user='root';flush privileges;exit

Execution Result:

Log out and log back in:

Comes with SQLYog pure cracked Chinese version download resources

After downloading and installing, just double-click the registry!

The effect is as follows:

Summarize

The above is the detailed installation tutorial of MySQL5.7.19 decompressed version introduced by the editor (with the pure cracked Chinese version of SQLYog), I hope it will be helpful to everyone. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!