MySQL download and configuration (copy 1)

---restore content starts---

MySQL database installation and configuration detailed

Directory

I. Overview

Second, MySQL installation

Third, successful installation verification

Iv. navicatformysql Download and use

I. Overview

MySQL version: 5.7.17

: Http://rj.baidu.com/soft/detail/12585.html?ald

Client Tools: Navicatformysql

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

Second, MySQL installation

Installation conditions:

1). NET framework4.0 (: Http://rj.baidu.com/soft/detail/15910.html?ald)

If Windows Server 2003 has an error during installation of the. NET framework4.0 Installation: The NET Framework 4.0 installation prompts a blocking issue: You must install the 32-bit Windows image processing component before you run Setup WIC

Please go to Microsoft official download the corresponding file installation can:

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

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

1, MySQL download after the file name is: Mysql_installer_community_v5.6.21.1_setup.1418020972.msi, as follows:

2, double-click, pop up the following window: (If the system is prompted, select Allow)

3. Installation Start screen

4, check I accept the license terms, such as:

5, choose Next, pop up the following window:

6, select the second: Server only, such as: ( This step selection is very important )

7, click Next, as follows:

8, can modify the path, can also not modify, modify the path as follows: (optional)

9. Click Next to go to the ready to install the interface

10, click to execute, install

11. Installation Progress

12. Complete Installation

13. Prepare the Configuration Interface

14, configure the server type and port number, by default you can

15, fill in the root user password, please remember the password

16. Fill in the password

17, set up user and service boot, by default

18. Confirm the configuration

19, confirm the configuration of the process, if there is a pop-up window, be sure to allow , as follows:

20. Complete the configuration

21. Complete

22. Complete Installation

Third, successful installation verification

1. Open the Command Line window

2. Enter the password

3. Enter the root password and press ENTER

4. Display Mysql> input mark

5. Enter display all database commands: show databases; Be sure to have a semicolon and press ENTER

6, display the system default 4 database

Iv. navicatformysql Download and use

1. The file name after download is: Navicatformysql.zip, as follows:

2, extract to the D-disk, as follows:

3, the implementation of documents:

4. Display the main interface after double-clicking

5, install the input in the download file can be

6. Main interface

7. Connection Database Configuration

8. Enter the root password

9. Display Connection

10. All database Details

11. Right-click to select Run SQL file ...

12. Select the SQL file to run

13. The database table execution file is selected here, click Start to execute.

14, display the execution results, successfully closed.

15. Run User SQL file

The database configuration is complete.

---restore content ends---

MySQL download and configuration (copy 1)