Download, install, and use of the MySQL client tool of the Mysqlsetup type

Description

First of all, note that in the MySQL official website, there is no mysqlSetup.exe

1. Download

2. Installation

1. New MySQL server directory

2. Installation: Double-click the Setup.exe file to start the installation of MySQL. The following window appears

3. Click Next to start the next installation. Default is typical, select Custom, (because typical mode does not allow to change the installation path, can only be installed on the C drive)

4, here need to select components and Change folder location, the component can be the default, the location to choose Change (

Note: The path to the installation of MySQL cannot contain Chinese)

5. Click Install to start the installation

6, installation completed, see below. Of course, we chose "Skip sign-up".

7, click to complete the "Finsh"

8, now start to configure the work. Click Next to continue.

Select Detailed Configuration and click Next.

9, the following option is the choice of MySQL application type

(The first is the development server, will only use as little memory, the second is a normal Web server, will use a medium amount of memory, the last is this server only run MySQL database, will occupy all the memory,) Here example Select Development Server, occupy as little memory, users can according to their own needs, Select a different option.

10, the next choice of database purposes,

(The first is multi-purpose, the database will be optimized to a good InnoDB storage type and efficient MyISAM storage type, the second is only for transaction type, the best optimization innodb, but also support MyISAM, the last type of non-transaction processing, suitable for simple applications, Only MyISAM types that do not support transactions are supported. The first type of multifunction is generally selected.

11, the following is the choice of data storage location, the default.

12, select the maximum number of connections allowed by MySQL, the first is the maximum number of 20 connection concurrency, the second is the maximum number of 500 concurrent connections, the last one is custom, you can choose according to their own needs

13, the following is the selection of the database listening port, the general default is 3306, if you change to another port, the subsequent connection to the database to remember the modified port, otherwise you can not connect MySQL database, more trouble, here do not modify, with mysq default port: 3306. Next, the default latin1.

14, the Latin code, the second is a multi-byte universal UTF8 encoding, is not our universal encoding, here Select the third, and then character set there to choose or fill in "GBK", of course, you can also use "gb2312", the difference is GBK font capacity is large, Includes all Chinese characters of gb2312, plus traditional characters, and other messy words-run "SET NAMES GBK" before executing data manipulation commands when using MySQL; (Run once on the line, GBK can be replaced with other values, depending on the settings here), you can normally use Chinese characters (or other text), otherwise it will not be normal display of Chinese characters. Of course our script is UTF8 encoding can also be selected by the user, you can also choose to press "Next" when creating the database.

15, choose whether to install MySQL as a Windows service, you can also specify the service name (the Services identity name), whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under the bin, instead of indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue. Choose whether to install MySQL as a Windows service, you can also specify the service name, or whether to add the MySQL bin directory to Windows PATH (after joining, you can directly use the file under Bin without indicating the directory name, such as connection, "Mysql.exe-uusername-ppassword;" You can, do not point out the full address of the Mysql.exe, very convenient), I have all ticked here, Service name unchanged. Press "Next" to continue.

To continue ...

Thanks to the following bloggers:

Http://www.cnblogs.com/xiaoxiaojia/p/5366704.html

Download, install, and use of the MySQL client tool of the Mysqlsetup type