Pitfalls encountered when installing the decompressed version of MySQL 5.7.20 (recommended)

MySQL official website:

https://www.mysql.com/downloads/

https://www.jb51.net/softs/451120.html

1. After the environment variables of the unzipped version are configured, there is no my.ini or my-default.ini file in the root directory

Create a new file my.ini and put it in the ./bin directory

[mysql] 
# Set the default character set of the mysql client to default-character-set=utf8  
[mysqld] 
#Set port 3306 port = 3306  
# Set the installation directory of mysql basedir=E:\Program Files\mysql-5.7.20-winx64 
# Set the storage directory of mysql database data datadir=E:\Program Files\mysql-5.7.20-winx64\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

2. Start the command line as an administrator, enter the installation directory bin directory, and use the command to initialize data

mysqld --initialize-insecure

3. Start the service net start mysql

Summarize

The above is the pitfalls encountered in the installation of the mysql 5.7.20 decompression version that the editor introduced to you. I hope it will be helpful to you. If you have any questions, please leave me a message and the editor will reply to you in time. I would also like to thank everyone for their support of the 123WORDPRESS.COM website!