The first step in database installation MySQL了, The basic installation methods are all here , So I'll sort it out here , On the one hand, review for yourself , On the one hand, it's convenient for everyone .

( about MySQL Written examination questions of , See the blog below for details :

( about MySQL Basic knowledge of , See the blog below for details :

( about MySQL Index knowledge of , See the blog below for details :

     MySQL Is a relational database management system , By Sweden MySQL AB Company development , Currently belongs to Oracle Subsidiaries .MySQL
The most popular relational database management system , stay WEB Application MySQL It's the best RDBMS (Relational Database Management
System, Relational database management system ) One of application software .

get ready :MySQL download

   Currently for different users ,MySQL Two different versions are available :

                          (1):MySQL  Community  Server  ( Community Edition ) 
This version is completely free , But the government doesn't provide technical support

                           (2):MySQL  Enterprise Server  ( Enterprise Edition )  
It can provide data warehouse applications for enterprises with high cost performance , support ACID Dealing with things , Provide complete submission , RollBACK , Crash recovery and row level locking function . But this version needs to be paid for , Official technical support for telephone and its documents

     Its download address :( The two methods are different , Here we focus on the installation package )
Compressed package :
Installation package :
1, get into MySQL Official website  

   The interface is as follows :

2, Enter the download interface , Find the bottom “MySQL Community Edition” Click hyperlink .


   Hyperlinks are as follows :

3, Go in and find the installation package MSI

4, click MSI, Then download





If you download it , It's like this :


One :MySQL Community Edition installation steps

Step 1 : Double click this package , Pop up installation window ( If prompted , Select allow )

Step 2 : Installation interface start

Step 3 : Tick I accept the license terms , As shown below :

Step 4 , Select next , The following window will pop up :

Step 5 : The choice of the items depends on your own will ( Here's the second one , If you just want to install My SQl Serving , Recommended options Server only)


Step 6 : path choice ( This is entirely personal )


Step 7 : Click Next , The schematic diagram is as follows :


Step 8 : Preparing for installation , Click execute .



Step 9 : After installation , Prepare configuration interface



Step 10 : Configure server type solar term port type , By default

Step 11 : fill in Root User password , Remember the password

Step 12 : Set user and service startup , By default

Thirteenth Step : Plug ins and extensions


Step 14 : Confirm configuration ( During configuration , If there is a pop-up window , Be sure to allow , Maybe it's a long time , Just wait a minute ok)

Step 14 : complete

Two , Database installation

1, Open downloaded mysql install files , Double click Run mysql-5.5.28-win64.msi.

2, Select installation type , Yes “Typical( default )”,“Complete( completely )”,“Custom( User defined )” Three options , choice “Custom”, Press “next” Key to continue . 


Three , Click Install , complete .

4, Installation is complete , The following interface will enter mysql Configuration Wizard .


5, Select configuration mode ,“Detailed Configuration( Manual precise configuration )”,“Standard
Configuration( Standard configuration )”, We choose “Detailed Configuration”, Easy to familiarize with configuration process . 

6, Select server type ,“Developer Machine( Develop test class ,mysql Take up little resources )”,“Server
Machine( Server type ,mysql Occupy more resources )”,“Dedicated MySQL Server
Machine( Dedicated database server ,mysql Occupy all available resources )”


7, choice mysql General purpose of database ,“Multifunctional Database( Versatile , good )”,“Transactional Database
Only( Server type , Focus on transactions , commonly )”,“Non-Transactional Database
Only( Non transactional , Simpler , Mainly do some monitoring , For counting , Yes MyISAM Data type support is limited to non-transactional), Press “Next” continue .


8, Select the number of concurrent connections to the site , Number of simultaneous connections ,“Decision Support(DSS)/OLAP(20 About )”,“Online Transaction
Processing(OLTP)(500 About )”,“Manual Setting( Manual settings , Lose a number by yourself )”. 

9, Enable or not TCP/IP connect , Set port , If not enabled , You can only access it on your own machine mysql Database , On this page , You can also choose “ Enable standard mode ”(Enable
Mode), such MySQL It won't allow minor grammatical errors . If it's new , It is recommended that you cancel the standard mode to reduce the trouble . But familiar MySQL in the future , Try to use standard mode , Because it can reduce the possibility of harmful data entering the database . Press “Next” continue  

10, That's right mysql Set the default database language code ( important ), General selection UTF-8, Press  “Next” continue .

11, Choose whether to mysql Installed as windows service , You can also specify Service Name( Service ID name ), Whether to mysql Of bin Add directory to Windows
PATH( After joining , It can be used directly bin Documents under , Without specifying the directory name , Such as connection ,“mysql.exe -uusername
-ppassword;” That's it , Don't point out mysql.exe Full address of , Very convenient ), I've ticked everything here ,Service Name unchanged . Press “Next” continue .

12, Ask if you want to modify the default root user ( Super management ) Password for .“Enable root access from remote
machines( Allow or not root Users log on to other machines , If you want to be safe , Don't tick it , If you want convenience , Just hook it up )”. last “Create An Anonymous
Account( Create a new anonymous user , Anonymous users can connect to the database , Unable to manipulate data , Include query )”, Generally, there is no need to tick , Setup complete , Press “Next” continue .

User name and password are set to :

user name :root( for example )

User password :****

13, Confirm the setting is correct , Press “Execute” Make settings effective , That's it MYSQL Installation and configuration of .

be careful : Setup complete , Press “Finish” There is a common mistake , Just can't “Start service”, It usually appears before installation mysql On , Solutions , First of all
Previously installed mysql The server was completely uninstalled ; If not , Check to see if you follow the above steps , Whether the previous password has been modified , Do as above ; If it still doesn't work , take mysql Under the installation directory data file
Folder backup , Then delete , After installation , Will install the generated  data folders removing , Backed up data Folder move back , Restart again mysql Just the service , In this case , You may need to check the database
once , Then fix it once , Prevent data errors .



Three , Install successfully verified

Step 1 : Open command line window

Step 2 : Input password

Step 3 : input Root password , And press enter

Step 4 : Enter show all database commands :show databases( There must be a semicolon , And press enter )

Three :NavicatforMySQL Download and use

   Genuine verification code


  Step 1 : The downloaded file name is, The schematic diagram is as follows :

Step 2 : decompression , The schematic diagram is as follows :

Step 3 : Schematic diagram of executive documents :

Step 4 : Double click to display the main interface


Step 5 : Just install the input in the download file


  Step 6 : Main interface connection to database configuration


Step 7 : Show connections , All database details can be viewed

Step 8 : Right click to select run SQL file , Then select

Step 9 : Select execution file , Click to run

Step 10 : Show execution results , Close successfully .( Success must be shown in the figure )

Step 11 : Run user SQL file


above , It's all about database configuration .