Mysql database installation and configuration details

Catalog

One 、 summary

Two 、MySQL install

3、 ... and 、 Successful installation verification

Four 、NavicatforMySQL Download and use

 

One 、 summary

　　MySQL edition ：5.7.17

　　 Download address ：http://rj.baidu.com/soft/detail/12585.html?ald

　　 Client tools ：NavicatforMySQL

　　 Green version download address ：http://www.cr173.com/soft/38153.html

 

  Two 、MySQL install

  The installation conditions ：

　　1）.net framework4.0（ Download address ：http://rj.baidu.com/soft/detail/15910.html?ald）

　　 If Windows Server 2003 In the installation .net framework4.0 Error during installation ： net framework 4.0 When installing, it is suggested that there is a blocking problem : Before running setup , Must install 32 position Windows Image processing components WIC

　　 Please go to the Microsoft official to download and install the corresponding files ：

　　32 position ：http://www.microsoft.com/en-us/download/details.aspx?id=32

　　64 position ：http://www.microsoft.com/en-us/download/details.aspx?id=1385

 

1、MySQL The name of the downloaded file is ：mysql_installer_community_V5.6.21.1_setup.1418020972.msi, The schematic diagram is as follows ：

2、 After the double-click , Pop up the following window ：（ If the system prompts , Choose to allow ）

 

3、 Installation start screen

4、 Check I accept the license terms, Here's the picture ：

5、 Select next , Pop up the following window ：

6、 Select the second term ：Server only, Here's the picture ：（ This choice is very important ）

7、 Click next , The schematic diagram is as follows ：

8、 You can modify the path , It can also be modified without modification , The schematic diagram of the modified path is as follows ：（ Optional ）

9、 Click next , Enter the ready to install interface

10、 Click on the perform , install

11、 Installation progress

12、 installation is complete

13、 Prepare the configuration interface

14、 Configure the server type and port number , The default can be

15、 Fill in Root User password , Please remember the password

16、 Fill in the password

17、 Set user and service startup , The default can be

18、 Confirm configuration

19、 In the process of confirming the configuration , If there is a pop-up window , Be sure to allow , The schematic diagram is as follows ：

20、 Complete the configuration

21、 complete

22、 installation is complete

 

 

3、 ... and 、 Successful installation verification

1、 Open the command line window

2、 Input password

3、 Input Root password , And press enter.

4、 Show MySQL> Enter the tag

5、 Enter the command to display all databases ：show databases; There must be a semicolon , And press enter.

6、 Display the default of the system 4 A database

 

Four 、NavicatforMySQL Download and use

 

1、 The name of the downloaded file is ：NavicatforMySQL.zip, The schematic diagram is as follows ：

2、 Unzip to D disc , The schematic diagram is as follows ：

3、 Schematic diagram of execution file ：

4、 Double click to display the main interface

5、 Search for a , Just type in

6、 main interface

 

7、 Connection database configuration

8、 Input Root password

9、 Show connections

10、 All database details

11、 Right click and select run SQL file ...

12、 Select the... To run SQL file

13、 The database table execution file is selected here （ Prepare one for yourself sql file ）, Click start to execute .

14、 Show execution results , Close successfully .

15、 Run the user SQL file （ You can skip this step ）

 

Database configuration completed .