MySQL 5.7.25 compressed version installation and configuration method graphic tutorial

This article shares the installation and configuration method of MySQL 5.7.25 compressed version for your reference. The specific content is as follows

Step 1: Download MySQL 5.7.25 compressed version

Download address: Click here to enter

Step 2: Install MySQL 5.7.25 compressed version

1. Unzip the compressed package to drive D. The path is: D:\mysql-5.7.25-winx64

2. Create a my.ini file in the D:\mysql-5.7.25-winx64 path and configure it as follows:

[mysqld]
 
#Set MySQL installation path basedir = D:/mysql-5.7.25-winx64
 
#Set the storage directory of mysql database data, which is data
 datadir = D:/mysql-5.7.25-winx64/data
 
#Set the database connection port port = 3306
 
#Set the character set of the MySQL server character-set-server=utf8
 
#Set the default storage engine of MySQL server default-storage-engine=InnoDB
#If the INNODB mode cannot be started, delete the log file starting with ib in the data directory and restart.
 
 
#Set the maximum number of connections max_connections=512
 
#Allow temporary storage in the query cache size query_cache_size=0

3. Configure environment variables (to allow commands such as mysql and mysqld to be used in the console in any path)

Edit the key name: Path value: D:\mysql-5.7.25-winx64\bin

4. In the D:\mysql-5.7.25-winx64\bin directory, enter cmd in the address bar to start the console in this path

Execute mysqld -install to install MySQL and register MySQL to the system service

Execute mysqld --initialize-insecure --user=mysql to initialize MySQL and generate a data directory

Execute net start mysql to start the mysql service

Execute mysqladmin -u root -p password to set a new password. Prompt Enter password: The initial password is blank, just press Enter, and then enter the new password root twice.

5. Complete the installation and connect to the database

mysql -h localhost -u root -p

[Note: In Windows 10, the above commands need to be executed under Windows PowerShell (Administrator)]

Wonderful topic sharing:

MySQL different versions installation tutorial

MySQL 5.7 installation tutorials for various versions

MySQL 5.6 installation tutorials for various versions

mysql8.0 installation tutorials for various versions

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.