Build MySQL database in Windows server2012 R2

I use server The environment is ​ ​3A The Internet ​​ Rented servers , Cheapness , High bandwidth

1. First go MySQL Download the installation package on the official website

2. Other downloads require login , Choose direct installation below

3. Then extract it into a folder （ Unzip this article C:\mysql-8.0.29-winx64）, And configure the initialized mi.ini file （ establish my.ini File and paste the following contents , Remember to create it under the decompression path first data Folder oh ）, After the file is created, put it in the decompression path ：C:\mysql-8.0.29-winx64 Next  

The contents of the document ：

[mysql]

# Set up mysql Client default character set

default-character-set=utf8

[mysqld]

# Set up 3306 port

port = 3306

# Set up mysql Installation directory

basedir=C:\mysql-8.0.29-winx64

# Set up mysql Database data storage directory

datadir=C:\mysql-8.0.29-winx64\data

# Maximum connections allowed

max_cnotallow=200

# 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

4. install MySQL, Administrator rights to use cmd Command enters the command window , And cd To the installation path bin Under the table of contents ,

mysql—install（ install ） If it is successful, it is shown in the figure below ：

mysqld --initialize （ initialization ）

net start mysql（ function ）

5. Change Password

stay data Inside the directory , find “.err” Final document , Open in Notepad , find “[email protected]”, Followed by the password

Log in successfully ,

modify MySQL Of root User password format ：mysqladmin -u user name -p Old password ; password New password