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

Because I often install the system, every time after installing the system, I have to reinstall some software, and when installing the software, I have to go online to find the installed tutorials, which is more troublesome, so I have sorted out the installation method of the MySQL5.7.21 decompressed version in order to check it.

1. First of all, you need to download the MySQL decompressed version, download address, illustration:

two。 Extract the installation package and choose the path according to your preference. The path I chose is C:\ software\, so the full path of MySQL is: C:\ software\ mysql-5.7.21-winx64

3. Configure environment variables

Add system environment variables:

Key name: MYSQL_HOME

The value is: C:\ software\ mysql-5.7.21-winx64

Add:% MYSQL_HOME%\ bin to Path. Note that the ";" symbol between different values in Path cannot be omitted.

4. When the my.ini file is ready, you can first create a new my.txt file, and then change the file suffix to .ini by renaming it. The my-default.ini file may exist after decompression in the previous version, but not in version 5.7.21, so you need to create the file manually. The contents of the file are as follows:

[mysqld] port = 3306 basedir=C:/software/mysql-5.7.21-winx64 datadir=C:/software/mysql-5.7.21-winx64/data max_connections=200 character-set-server=utf8 default-storage-engine=INNODB sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES [mysql] default-character-set=utf8

Note that the installation path of MySQL is in the red box, and use "/" instead of "\" between folders, otherwise errors may occur in the following operations

After editing the my.ini file, place the my.ini file in the C:\ software\ mysql-5.7.21-winx64 directory

5. Open the cmd command window as an administrator and change the directory to the bin directory of the installation directory of MySQL

6. Execute the following statement to install MySQL

Mysqld-install

Prompt after executing the command: Service successfully installed. Indicates a successful installation

7. Execute the following statement to initialize MySQL

Mysqld-initialize-insecure-user=mysql

After executing the command, the data directory is generated under the installation directory of MySQL and the root user is created.

8. Execute the following command to start the mysql service

Net start mysql

After execution, there will be the following prompt:

The MySQL service is starting..

The MySQL service has started successfully.

9. After starting MySQL, the password for the root user is empty. Set the password as follows:

Mysqladmin-u root-p password New password Enter password: old password

When you need to enter the old password, you can enter directly because the old password is empty.

The MySQL5.7.21 decompression version has been installed.

Wonderful topic sharing: different versions of mysql installation tutorials mysql5.7 various versions of installation tutorials

The above is the whole content of this article, I hope it will be helpful to your study, and I also hope that you will support it.

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.