original text ：https://www.cnblogs.com/winton-nfs/p/11524007.html

install-free Mysql

MySQL Guan is a relational database management system , What is used SQL Language is the most commonly used for accessing databases

Standardized language , It is characterized by small volume 、 Fast 、 Low total cost of ownership , Especially open source , stay Web

Application aspect MySQL It's the best RDBMS(Relational Database Management System： Relational data

Library management system ) One of the application software .

In this post , I mainly use Mysql For example, install free version , Help you with installation and configuration mysql Steps for .
One ： Download installation package ：
① After entering the official website , Click on "Dowload", And then the page goes down

② The next page is like this , The link in the red box is mysql Community Edition , It's free. mysql edition , Then we click the link in this box ：

③ Next, go to this page , ad locum , We just download the community version of Server That's all right. ：

④ Download the installation free version (windows Except for other systems )

such , The installation package will be downloaded ！
Be careful , The installation directory should be in the specified location ,, secondly , Avoid Chinese... In absolute path , It is recommended to choose English as the naming condition ！！！！( My for reference )

Two ：Mysql Configuration of

Open the command line as Administrator ( As shown in the figure below )

① Go down to mysql Of bin Under the table of contents ：

② install mysql Service for ：mysqld --install

③ initialization mysql, ad locum , Initialization produces a random password , As shown in the picture box below , Remember this password , We'll use that later (mysqld --initialize --console)

④ Turn on mysql Service for (net start mysql)

⑤ validate logon ,mysql Is the installation successful ！( Pay attention to the random password generated above , Do not include spaces in front of the preceding symbols , Otherwise, it will fail to log in ), If it's the same as the figure below , It means your mysql Installed successfully ！ Be careful ,, Be sure to start the service first , Otherwise, the login will fail , An access denied prompt appears ！！！
Change Password ：
　　　　 The random password generated due to initialization is too complex ,, It's not convenient for us to log in mysql, therefore , We should change a password that we can remember ！！
Log in again to verify the new password ：
Set the global variables of the system ：
For the convenience of login operation mysql, Here we set a global variable ：
① Click on " My computer "–>“ attribute ”–>’‘ Advanced system setup ’’–>’‘ environment variable ’’, Next, as shown in the figure below

② Put the new mysql Variable added to Path In the path variable , Click ok , That is to finish ：

Once the configuration is complete , Whenever we want to use the command line mysql when , It only needs win+R,–> Input "cmd" Open the command line , Then enter login sql Sentence can be used .

③ stay mysql Create one in the directory ini or cnf The configuration file , What I created here is ini The configuration file , The code in it is mysql Some basic configuration of （ It's not necessary ）

That's it , An installation free version of Mysql Just install and configure , beginner , Try not to use mysql The compiler ,, It is recommended to practice with the command line until you are proficient ~

Reference resources ：

① Installation services ：mysqld --install

② initialization ：　mysqld --initialize --console

③ Opening service ：net start mysql

④ Close the service ：net stop mysql

⑤ Sign in mysql：mysql -u root -p

Enter PassWord：( password )

⑥ Change Password ：alter user ‘root’@‘localhost’ identified by ‘root’;(by Then there's the code )

⑦ Mark deletion mysql service ：sc delete mysql