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

This article gives you an example of how to install and configure mysql 5.7.25 compressed version for your reference. The details are as follows

Step 1: download MySQL 5.7.25 compressed version

Download address: click to enter

Step 2: install MySQL 5.7.25 compressed version

1. Extract the compressed package to disk D, and the path is D:\ mysql-5.7.25-winx64

2. Create a new my.ini file under the D:\ mysql-5.7.25-winx64 path with the following configuration:

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

3. Configure environment variables (in order to make mysql, mysqld and other commands available on the console under any path)

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

4. Under the D:\ mysql-5.7.25-winx64\ bin directory, type cmd at the address bar to start the console under this path

Execute mysqld-install to install MySQL and register MySQL with 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 the new password

Prompt Enter password: the initial password is empty, enter directly, and then enter the new password root twice.

5. Complete the installation and connect to the database

Mysql-h localhost-u root-p

[note: under win10, you need to execute the above command under Windows PowerShell (administrator)]

Wonderful topic sharing:

Installation tutorials for different versions of mysql

Installation tutorials for each version of mysql5.7

Installation tutorials for each version of mysql5.6

Installation tutorials for each version of mysql8.0

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.