mysql5.7.19 winx64 decompressed version installation and configuration tutorial

Recorded the installation tutorial of mysql 5.7.19 winx64 decompression version, the specific content is 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 port = 3306

[mysqld]
#Set port 3306 port = 3306
# Set the installation directory of mysql to basedir=C:\mysql
# Set the storage directory of mysql database data datadir=C:\mysql\data
# Maximum number of connections allowed 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 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!

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.