MySQL zip installation tutorial

install mysql Previous suggestions ：

It is recommended not to install the latest version , General mysql5.0 Series version is OK ; I just found a random version MySQL, The latest edition 8.0.28
mysq1 Official website .zip and .msi There are two types of installation ;
zip It's a compression pack , Decompress directly after the use of , You need to configure everything yourself ;msi Is the installation package , The system helps us install it directly ;
Novices suggest using msi Installation mode ; Recommended for old birds zip Installation mode , Problems can be solved easily ;

Let's introduce zip Installation method of decompressed version ：

First, in the MySQL Download the version you want on the official website MySQL; link : MySQL Download address .
Unzip the package to the location you want to install ： Choose here C:\JavaDev\MySQL;
Then in the installation file directory C:\JavaDev\MySQL\mysql-8.0.28-winx64 Next , newly build mysql.ini The configuration file ;
Open it with notepad , The edit content under the file is as follows ：

[mysql]
default-character-set=utf8
[mysqld]
#  Set up 3306 port 
port = 3306
#  Set up mysql Installation directory 
basedir = C:\\web_soft\\mysql-8.0.17-winx64\\
#  Set up mysql Database data storage directory 
datadir = C:\\web_soft\\mysql-8.0.17-winx64\\data
#  Maximum connections allowed 
max_connections=20
#  The character set used by the server defaults to 8 Bit coded latin1 Character set 
character-set-server=utf8
#  The default storage engine that will be used when creating a new table 
default-storage-engine=INNODB
#  Create mode 
sql_mode = NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

Copy, edit and save ;

Next, configure the environment variables ： Computer — attribute — Advanced system setup — environment variable , add to MySQL Decompression path . Remember it was bin Under the table of contents ;

Then use the Administrator powershell panel , Yes mysql Installation ;
First enter your installation directory ,eg：C:\JavaDev\MySQL\mysql-8.0.28-winx64
Input mysqld --initialize-insecure, Execute this command to initialize data Catalog , You can see the new folder under the installation directory data Folder ;

Be careful ： Enter this initialization command ,mysql Your initial password is set to none ; Input mysql -uroot -p When prompted for a password , direct enter Just go ;

Then install mysqld service ： Input mysqld --install command , install mysqld service :
Here we need to pay attention to ; If an error is reported the service already exist; Uninstall before instructions mysql It was not uninstalled completely at the time of ,mysql The service still exists ; You need to remove mysql service , Reference article ： link .
Then start mysql service , Input net start mysql, Start the service

Sign in mysql： perform mysql -u root -p command , As mentioned above , Initial password none , direct enter;

Set up root Initial password ：

use mysql;
ALTER user 'root'@'localhost' IDENTIFIED BY ' New password ';
FLUSH PRIVILEGES;

Modified to complete , Check the user password ：

select host,user,authentication_string from mysql.user;

sign out mysql： Input exit, sign out MySQL;
Here we are ,mysql The installation is over , You can log in and use normally mysql 了 .

Tips

mysqld –initialize-insecure Automatically generate no password root user ;
mysqld –initialize Automatically generate... With random password root user ;
mysqld -remove Remove your own mysqld service ;
net stop mysql command , stop it mysql service
   If you make a mistake , Empty data Folder , It's better to delete data file , Re execution remove–initialize–install–start（ These are not orders ） Just the process ;