MySQL installation and basic use under Windows

First, the installation method

1.msi

2.zip

Here we use the MSI bar, just practice words, a lot simpler

Second, MSI installation

1. Click on the installation file and click Next on the Installation Wizard that appears.

　　　　

2. Agree to the MySQL User License agreement, then next

　　

3. Select the installation type

(1) Typical Typical installation: server and client that will install MySQL

(2) Custom Customized installation: Select the installation components according to user needs

(3) Complete Full installation: Will install all the components of the entire MySQL

So here we choose a typical installation to use on it.

　　

4. Then click Install

　　

5. Installation process: File copy

　　

6. When the previous step is completed, an ad will appear, directly next

　　

7. Continue the ad and click Next

　　

8. The installation is complete, and asked whether to configure the operation, here temporarily uncheck the configuration operation, the direct point installation is complete.

　　

Third, the configuration of MySQL

1. Locate the Configuration Wizard file (the same check box is checked in the last step of the second)

　　

　　

2. Run the Configuration Wizard file, the Welcome screen appears, direct next

　　

3. Select the Configuration type: Select Standard configuration (beginner fit)

　　

4.mysql and Windows Services, environment variable settings, usually ticked on and next

　　

5. Set the root user's password and then direct next

　　

6. After the configuration is complete, execute executes

　　

7. Configuration Complete

(1) Prepare configuration: Preparing profiles and information

(2) Write config file: Write the configuration files, followed by the path of the configuration file is generally the My.ini file under SQL Server

(3) Start service: Open SQL Server service

(4) Apply security settings: Apply secure settings (that is, the configuration that just set the root password)

　　

Iv. verifying configuration and modifying configuration files

1. Verification Services

　　

2. Environment variables

　　

With this, we can guarantee that all executables under the bin subdirectory can be called under any directory.

3. Understand the directory structure under the installation directory to configure

　　

4.my.ini Configuration file Modification

(1) Encoding method

　　　　

(2) My.ini file internal parsing and configuration

　　　　

　　　　

V. Basic use of MySQL

1. Start and stop the MySQL service

(1) Enter the service interface switch under Windows

　　　　

(2) command line implementation switch MySQL service

"1" cmd into command line mode

"2" direct net start/stop mysql switch mysql service

　　

MySQL installation and basic use under Windows