Detailed tutorial on installing MySQL 5.7.19 decompressed version on Windows Server 2016

The installation tutorial of MySQL 5.7.19 winx64 decompressed version is recorded. The specific contents are as follows

System environment: Win7 x64

Software preparation: MySQL 5.7.19 winx64

Download URL: https://dev.mysql.com/downloads/mysql/

Configuration and installation process

The specific installation is as follows:

1. Unzip the mysql-5.7.19-winx64.zip compressed file to the C:\MySQL\ directory;

2. Create a new my.ini configuration file in the C:\MySQL\ directory;

3. Open the my.ini file with a text editor or other editor, copy and paste the following code into it, save and exit;

#Code start [Client]
#Set port 3306
 = 3306
[mysqld]
#Set port 3306
 = 3306
#
 Set the installation directory of MySQL to basedir=C:\mysql
#
 Set the storage directory of MySQL database data datadir=C:\mysql\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 is default-storage-engine=INNODB
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
[mysql]
#
 Set the default character set of the MySQL client to default-character-set=utf8
#End of code

4. Configure environment variables;

4.1. Create a new system variable MYSQL_HOME and set the variable value to C:\mysql;

4.2. Edit the system variable Path and add %MYSQL_HOME%\bin to the end of the Path variable value.

5. Run the command prompt cmd as an administrator (it must be run as an administrator, otherwise the permissions are insufficient);

5.1. Use the DOS command to enter the C:\mysql directory and run the following command

mysqld
 --defaults-file=my.ini
 --initialize-insecure
mysqld
 --install
net
 start mysql

5.2. Set the root password of mysql and run the following command

mysql

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

At this point, the configuration and installation of the MySQL 5.7.19 winx64 decompression version has been completed! I wish you success!

Summarize

The above is a detailed tutorial on how to install the unzipped version of MySQL 5.7.19 on Windows Server 2016. I hope it will be helpful to you. If you have any questions, please leave me a message and I will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!